VBA Code Samples

How to use Len, Left, Right, Mid, and InStr to extract text from Microsoft Outlook fields and message bodies.

How to create a toolbar button in Outlook 2007 or Outlook 2010 to open templates and files and disable the security warning dialog that displays before the template or files opens.

A favorite request is the ability to see what dates a recurring appointment or meeting is scheduled for. You can use VBA to create a list of all dates in an recurring appointment or meeting.

How to choose the folder to save sent messages in when using Microsoft Outlook. Lotus Notes can prompt the sender to specify what folder a message should be saved in, Outlook doesn't (unless you use VBA code). However, there are methods you can use to move sent messages to a new folder.

How to read MAPI properties that are not exposed in the VBA Object model using the Property Accessor object.

How to quickly apply a business card layout to all Outlook contacts so they all use one layout.

Although you can't save new contacts directly in the iCloud contacts folder unless you select the iCloud Contacts folder before opening the new Contact form, there are a couple of options available to move new contacts to the iCloud.

An Outlook user asked how to automatically change the subject of a message and forward it to another address. Using a "run a script" rule is one option and we show you how to do it.

How to rename Exchange account display names that are shown in the navigation pane and From field in Outlook 2013.

Do you accidently send messages to the wrong email address? You can use a VBA macro that checks the outgoing addresses before sending the message.

How to create a list of the folders in Microsoft Outlook data files. This code works with any data file in the Outlook profile.

Many users have a problem with Outlook missing misspelled words. In many cases this happens because the person is typing in the signature field, either accidentally or intentionally.

So you found some code on the Internet that you think might do what you need done. But how do you use it? First you need to open the VBA Editor by pressing Alt+F11. Expand Microsoft Outlook Objects Double click on ThisOutlookSession to open it in the editing pane on the right side. Paste (or  

The code behind Microsoft Outlook forms is always written with the Microsoft Visual Basic Scripting Engine, better known as VBScript, a small portable language, which is also used in web pages and standalone scripts. VBScript does not support the built-in Outlook constants, such as olFolderContact. Only the constants built into VBScript, such as vbYes, are supported. For  

How to create a custom field to mark messages that were responded to in Microsoft Outlook.