‘HowTo samples’ category archive
Office 365 – Save Outlook e-mails & attachments to SharePoint Online programmatically
Pieter van der Westhuizen | January 19th, 2012
If you're following Ty's Office 365 Newswires and read this article about Microsoft already having sold five million Office 365 seats in roughly two and a half months, I'm sure you would agree with me that Office 365 is set to change, if not revolutionize the way people use and interact with Microsoft Office.
... Read the rest of this entry →
How to navigate through the Microsoft Office Command Bar system
Andrei Smolin | January 16th, 2012
There are 4 instances of the command bar button "Save" (Id=3) in Excel. Two of them are best known: a button on the Standard commandbar and an item in the File menu. The other two instances are buried in the command bar system... Read the rest of this entry →
HowTo: get the actual type name behind System.__ComObject with Visual C# or VB.NET
Andrei Smolin | December 20th, 2011
Developers accessing Application.Selection and Application.ActiveSheet in Excel or Explorer.Selection.Item(i), Folder.Items(j), Inspector.CurrentItem in Outlook do know the notorious "System.__ComObject" string. It indicates that the actual type of the COM object is unknown... Read the rest of this entry →
How to handle Outlook item’s Reply event: replying from a context-menu
Andrei Smolin | December 14th, 2011
Let's consider the case then the user replies to an Outlook e-mail from the context menu. First off, you can reply to one item only; that item is selected or right-clicked in an explorer window or is opened in an inspector window.... Read the rest of this entry →
How to handle Outlook item’s Reply event: tracking Inspector.Activate
Andrei Smolin | December 13th, 2011
In my previous article I explained the Reply event and parameters it provides. Also, I described a class handling this event in a version-neutral way. Now what I want is to show how you intercept Outlook's Inspector.Activate event.... Read the rest of this entry →
How to handle Outlook item’s Reply event: tracking Explorer.SelectionChange
Andrei Smolin | December 8th, 2011
Add-in Express implements a version-independent approach to handling events of an Outlook item. The class implementing this is called ADXOutlookItemEvents. I recommend that you regard this class as a set of event handlers; you can implement several such classes to follow several business rules... Read the rest of this entry →
How to create a custom event when Excel calculation mode changes
Andrei Smolin | December 5th, 2011
You should be aware that no such event exists. Let's create it. In Excel 2007 - 2010, you can change the calculation mode using the buttons shown in the screenshot below... Read the rest of this entry →
HowTo: Handle events of an Outlook item
Andrei Smolin | November 28th, 2011
There are two variants of handling events of an Outlook item. You can connect to events of an item shown in the active inspector window. In addition, you can connect to events of an item selected in the explorer window... Read the rest of this entry →
How To: Use Restrict method in Outlook to get calendar items
Eugene Astafiev | November 15th, 2011
I described how to use the Find and FindNext methods against calendar items in my previous post. Today I would like to take closer look at how to deal with calendar items using the Restrict method... Read the rest of this entry →
How To: Retrieve Outlook calendar items using Find and FindNext methods
Eugene Astafiev | November 11th, 2011
In my previous articles I described how to use the Find and FindNext methods of the Items class against mail and contact items. Today we will have a closer look at calendar items... Read the rest of this entry →
Outlook NewMail unleashed: writing a working solution (C# example)
Pieter van der Westhuizen | November 10th, 2011
In the previous part we looked at using Extended MAPI to handle new mails in Outlook and despite the fact that is does a pretty decent job of it, it still has some serious limitations. In this, the fourth and final part of the series, we will write our own solution to the problem
... Read the rest of this entry →
How To: Create a new recurring Outlook Appointment item
Eugene Astafiev | November 7th, 2011
In my previous article I described how to create a new Outlook Appointment item. Now I want to show you the way to create a new recurring appointment item in Outlook. Unfortunately the Outlook Object Model doesn't provide any intuitive property or method for such a task... Read the rest of this entry →
How To: Create a new Outlook Appointment item
Eugene Astafiev | November 4th, 2011
There are three ways of creating a new appointment item in Outlook. Today we will examine each of them in depth... Read the rest of this entry →
How To: Get a list of Outlook contacts
Eugene Astafiev | October 27th, 2011
A while ago I described two ways of getting Outlook Contact items from a folder: by using the Find/FindNext and Restrict methods of the Items class. Today I am going to show you the way of getting a list of all contacts of a certain Outlook user... Read the rest of this entry →
How To: Retrieve Outlook Contact items using Restrict method
Eugene Astafiev | October 21st, 2011
In one of my previous articles I demonstrated the way of using the Restrict method against mail items. Now I am going to use this method against Contact items in Outlook... Read the rest of this entry →
How To: Use Find and FindNext to retrieve Outlook Contact items
Eugene Astafiev | October 19th, 2011
Not so long ago I described how to use the Find and FindNext methods to retrieve Outlook mail items from a folder. Today I am going to replace a mail item declaration with a contact declaration. There is no difference between mail and contact items in case we use the Find and FindNext methods... Read the rest of this entry →