![]() ![]() ![]() Select the newly added ADXRibbonContextMenu control and set its ContextMenuNames property to: Start by adding new ADXRibbonContextMenu item to the AddinModule design surface. ![]() Our UI in Outlook will be far simpler than our Excel UI as we’ll only add an item to the Contact context-menu in the Outlook Explorer. On the reverse side we would like to export Outlook data to Excel. When running the add-in in Excel it should look like the following image: Next, add event handlers for both radio buttons’ CheckedChanged events and add the following code to it: private void rbContactData_CheckedChanged ( object sender, EventArgs e ) ) We’ll use the DataTable to store the column mappings between the data in the Excel sheet and Outlook’s Contact or Appointment items. I’ve also added a DataSet to the form, which contains one DataTable with three DataColumns. The following task pane consists of two radio buttons: (i) a DataGrid view control and a button as well as (ii) a panel and a number of label controls. We’ll design the new custom task pane as we would any standard Windows form. Next, add an advanced Excel Task Pane to the COM add-in project: Start by adding an ADXExcelTaskPaneManager component to the AddinModule designer surface. We’ll add an advanced Excel task pane, which will have our main UI for the add-in. Next, select your programming language of choice (C#, VB.NET or C++.NET) and the minimum version of Office that will be supported by your add-in and finally select both Microsoft Excel and Microsoft Outlook as the supported applications. Start by creating a new COM Add-in project for Outlook and Excel in Visual Studio. ![]() Creating the Outlook and Excel add-in projectĬreating the Outlook and Excel add-in project.Now, the standard functionality is fine, but let’s try and make it even easier for our customers to import and export data either from Excel to Outlook or from Outlook to Excel by writing our own shared Excel and Outlook add-in. The standard Outlook import/export functionality takes you through a series of forms and even allows you specify field mappings. In Outlook 2013 you can find the Import/Export function in the File or Backstage view menu, under Open & Export. Importing contacts and appointments into Microsoft Outlook is a feature that has existed in Outlook for a while. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |