Posts Tagged ‘COM add-ins’
Outlook NewMail unleashed, part 4 – Writing your own solution
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 →
Why doesn’t Excel quit?
Andrei Smolin | November 4th, 2011
From my experience, Excel doesn't quit because there's a COM object left unreleased either in your code or in the code of a COM add-in loaded in Excel. That is, to debug such an issue, you need to start with turning all COM add-ins off... 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 →
Outlook NewMail unleashed, part 3: Extended MAPI
Pieter van der Westhuizen | November 1st, 2011
In part 3 of the Outlook NewMail Unleashed series, we will be moving the theory aside and rather focus on the code. Let us write an add-in using Extended MAPI and Add-in Express 2010 for Office .net
... 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 →
Outlook NewMail unleashed, part 2: solution options
Pieter van der Westhuizen | October 24th, 2011
In part one of the Outlook NewMail Unleashed series we took a closer look at the challenge of effectively handling a new e-mail in Outlook. We've seen that the obvious choice of NewMail, NewMailEx and Items.ItemAdd is simply not the answer. In this post we'll investigate possible work-arounds and alternatives to NewMail, NewMailEx and Items.ItemAdd... 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 →
How to add PivotTables and Slicers to MS Excel programmatically
Pieter van der Westhuizen | October 17th, 2011
As I've mentioned in my previous article Excel enables us to provide our users with interactive and powerful ways to visualize their data. Pivot tables add another dimension to this by summarizing thousands of records of data in one page and let you analyse trends in your data without the need for formulas... Read the rest of this entry →
How To: Send a Contact item in Outlook programmatically
Eugene Astafiev | October 14th, 2011
There are three ways of sending a contact in Outlook. Today we will examine them in detail. Please note that the ContactItem class doesn't provide the Send method like the MailItem class does... Read the rest of this entry →
Invoking a COM add-in from an Excel XLL add-in: advanced sample
Andrei Smolin | October 11th, 2011
Really often, when I saw an error returned by an Excel formula, I thought about the poor possibilities that this error-reporting approach – a remnant of bygone concepts – provides for developers. The very first time I thought about showing a custom task pane from a UDF was when Add-in Express allowed showing custom panes in Excel; it was back in 2007... Read the rest of this entry →
How To: Create a new Outlook Contact item programmatically
Eugene Astafiev | October 7th, 2011
Not so long ago I described various ways of creating Outlook messages programmatically. Today we will examine contact items. The first and easiest way of creating a new Contact item in Outlook is to use the CreateItem method of the Application class... Read the rest of this entry →
How To: Perform Send/Receive in Outlook programmatically
Eugene Astafiev | October 5th, 2011
Today I will continue my series of "How To" articles explaining the basics of Outlook development. The NameSpace class in Outlook provides a programmatic equivalent of the "Send/Receive All" command – SendAndReceive method
... Read the rest of this entry →
How to use Evaluate to invoke an Excel UDF programmatically
Andrei Smolin | October 3rd, 2011
Whether your UDF is a VBA macro or an Excel Automation add-in or even an XLL add-in, you can invoke any method it provides to the user. To do this, you need to get or create an Excel.Application object and invoke ExcelApp.Evaluate() supplying it with the correct syntax for your method and its parameters.... Read the rest of this entry →
Outlook NewMail unleashed, part 1: the challenge
Pieter van der Westhuizen | October 3rd, 2011
A while ago Eugene asked me whether I would be interested at taking an in-depth look at how to effectively handle a new mail in Microsoft Outlook. I mean how hard could it be? We have the NewMail and NewMailEx events and if all else fails we can use the Folder Item Add event, right... Read the rest of this entry →
