‘Add-in Express for Office and .net’ category archive
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 get and set the format of an Outlook email message
Andrei Smolin | September 19th, 2011
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 →
Outlook Items and Folders events explained: C# code sample
Pieter van der Westhuizen | September 13th, 2011
In this post, we'll have a closer look at two classes provided by Add-in Express: the Outlook Folders Events class and the Outlook Items Events class. I'll be using Add-in Express 2010 for Office and .Net and Visual Studio 2010... 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 →
Video: Building an Excel RTD server
Ty Anderson | September 8th, 2011
Using Add-in Express you have the tools you need to rapidly start building a Real-Time Data (RTD) Server for Excel. This video shows you to use ADX to build a simple RTD... Read the rest of this entry →
Outlook Item events explained: C#, VB.NET
Pieter van der Westhuizen | September 6th, 2011
Spring has finally sprung down here and I thought today would be a great day to dive into the Outlook Item Events Class provided by Add-in Express and have a closer look at what each event in this class does... 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 →
Video: Developing an Excel Automation Add-in
Ty Anderson | August 31st, 2011
As a follow up to the Creating managed Excel UDFs video, here is a video that explains how to build UDFs using Excel Automation add-ins. In addition to a solid demo, this video explains the differences between an UDF built with an Automation Addin and one built as an XLL... 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 →
How To: Add a custom property to the UserProperties collection of an Outlook e-mail item
Eugene Astafiev | August 19th, 2011
Today I want to tell you the story about Outlook user properties. Each item in Outlook such as MailItem, AppointmentItem, ContactItem and etc. (except for the NoteItem) provides you with the UserProperties property which returns an instance of the UserProperties class... Read the rest of this entry →
How To: Get a list of Outlook attachments
Eugene Astafiev | August 15th, 2011
As a developer, sometimes you may want to know what is attached to the e-mail you have selected or opened in Outlook. Today I will show you how to iterate over the attachments collection and get the required information about attached items, such as file name, display name and type... Read the rest of this entry →
How To: Add an existing Outlook e-mail message as an attachment
Eugene Astafiev | August 12th, 2011
Now I want to show you how to attach an e-mail instead of a regular file. For such task I created a simple method in the code called AddMessageAsAttachment. This method attaches a MailItem object to the e-mail message and accepts two parameters: the first is the container e-mail message and the second one is an e-mail message which should be attached... Read the rest of this entry →