‘HowTo samples’ category archive
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 →
Add an image URL to Twitter from Internet Explorer programmatically
Pieter van der Westhuizen | October 12th, 2011
In today's post I'll demonstrate how to write an Internet Explorer add-in to add an image url to a Twitter message. I'll be using Add-in Express for Internet Explorer... 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 →
HowTo: Replace the standard Outlook Task UI
Pieter van der Westhuizen | September 28th, 2011
Add-in Express for Office and .net version 6.4, introduced us to the CompleteReplacement Outlook form region in March this year. With this region you are able to completely replace the entire area of an Outlook Inspector... Read the rest of this entry →
How To: Get unread Outlook e-mail items from the Inbox folder
Eugene Astafiev | September 27th, 2011
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 →
How To: Use Restrict method to retrieve Outlook mail items from a folder
Eugene Astafiev | September 23rd, 2011
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 add sparklines and charts to MS Excel programmatically
Pieter van der Westhuizen | September 21st, 2011
The charting engine for Excel took a leap forward with the release of Office 2007. However, the engine was slower than Excel 2003's version and also introduced a few bugs. Luckily Excel 2010 fixed those bugs and is back to being fast. Sparklines, a word-sized chart has also been introduced in Excel 2010... Read the rest of this entry →
How To: Use Find and FindNext methods to retrieve Outlook mail items from a folder (C#, VB.NET)
Eugene Astafiev | September 20th, 2011
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: Change an Outlook e-mail message before sending using C# or VB.NET
Eugene Astafiev | September 12th, 2011
As a developer you may want to modify an e-mail before sending it (or just add some information, such as a non-disclosure agreement etc.). It is a fairly simple task that every Outlook developer should be familiar with. For example, sometimes you may need to change the subject of a message by adding an ID or something else to track the item in your Inbox; add something to the e-mail body... Read the rest of this entry →
How To: Fill TO,CC and BCC fields in Outlook programmatically
Eugene Astafiev | September 8th, 2011
In my previous article, where I showed how to create and send an Outlook message programmatically, I added a recipient to the e-mail. Now I want to delve deeper and show you what you can do with the Recipients collection. Outlook developers frequently need to add recipients to the TO, CC and BCC fields... Read the rest of this entry →
How To: Create and send an Outlook message programmatically
Eugene Astafiev | September 2nd, 2011
Today I want to tell you the story about sending messages in Outlook programmatically. In one of my recent posts I showed two possible ways of creating and showing a new Outlook message. And now I want to make an addition to that: demonstrate how you can send a message programmatically... Read the rest of this entry →
How To: Create a new Outlook message based on a template
Eugene Astafiev | August 31st, 2011
In my previous article, where I demonstrated how to create and show an Outlook message programmatically, a mail item object was created from scratch. Now I want to show you the way to create a new mail item based on a template... Read the rest of this entry →
How to create and show a new Outlook mail item programmatically: C#, VB.NET
Eugene Astafiev | August 26th, 2011
One of the most widespread tasks in Outlook is creating and showing an e-mail item to the user programmatically (or just sending it silently). Today I will teach you how to do it in two different manners.... Read the rest of this entry →
How To: Get Outlook e-mail item’s custom properties – C# and VB.NET samples
Eugene Astafiev | August 24th, 2011
In my previous article How To: Add a custom property to the UserProperties collection of an e-mail item in Outlook I showed you the way to add a custom property to the UserProperties collection of an e-mail item in Outlook. Now I want to demonstrate you how to iterate over all user properties of an e-mail item... Read the rest of this entry →