Posts Tagged ‘VB.NET’

How To: Create a new recurring Outlook Appointment item

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

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

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

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

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: Send a Contact item in Outlook programmatically

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

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

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 →

Thread-safe XLL. How to get the caller address

The implementation of ADXExcelRef.ConvertToA1Style (ConvertToR1C1Style) uses xlfRefText which is NOT thread-safe as per Financial Applications Using Excel Add-in Development in C/C++ (2nd edition). On the other hand, xlSheetNm returning the sheet name is thread-safe. It means that the thread-safe way to get the caller address is to write some code... Read the rest of this entry →

How To: Perform Send/Receive in Outlook programmatically

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 →

Creating a fast Excel add-in (C#, VB.NET). Reading and updating cells.

This is a known problem: doing things cell by cell in Excel is a slow operation. The Excel object model provides two ways to speed up the code... Read the rest of this entry →

How To: Get unread Outlook e-mail items from the Inbox folder

In my previous articles we discussed the Find, FindNext and Restrict methods of the Outlook Items class. You can use these methods for retrieving unread items in the way I did... Read the rest of this entry →

Fast Excel add-in. Checking incoming data in XLL

When in an Excel UDF you need to check incoming data and replace incorrect values, you can use the modified-in-place argument, the XLL feature supported by Add-in Express 2010 for Office and .net. ... Read the rest of this entry →

How To: Use Restrict method to retrieve Outlook mail items from a folder

In my previous article I demonstrated how you can use the Find and FindNext methods of the Items class in Outlook. Today I want to show you an alternative way of retrieving Outlook mail items from a folder. As the post's title suggests, the Restrict method plays the key role in the process... Read the rest of this entry →

How To: Use Find and FindNext methods to retrieve Outlook mail items from a folder (C#, VB.NET)

As you have probably guessed, this article will describe the Find and FindNext methods of the Outlook Items class. But before focusing on the functionality of these methods, I would like to draw an analogy with database programming in the .NET world. In ADO.NET there is the System.Data.SqlClient.SqlDataReader class which provides the Read method... Read the rest of this entry →

How to get and set the format of an Outlook email message

Outlook supports creating emails in plain-text, HTML and RTF (rich-text) formats. To get or set the format of an email message, you use the MailItem.BodyFormat property; it isn't available in Outlook 2000. The value returned by the property is one of the Outlook.OlBodyFormat constants... Read the rest of this entry →

Have any questions? Ask us right now!