VBA Code Samples

I have a Days of the Year HOL file that creates all day events that count the days of the year, up and down "Day 5: 360 to go" but as the days are past, I don't need to know what day it was and prefer a cleaner calendar. While it's easy enough to delete  

Step-by-step instructions you can use to delete or hide the default folders (such as the junk email and suggested contacts folders) that Microsoft Outlook creates in your data files.

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

Use VBA to export a photo from a contact and save it to the hard drive. Use a second macro to add the photo to a new contact.

Use PowerShell or VBA to get the creation date of a folder in Outlook desktop software.

How to use a macro to resend a sent message in Outlook 2013 and Outlook 2016.

How to use PowerShell to bulk change Outlook Contact fields, including the File As and Email display name fields.

Use VBA to check the subject of every message you send (new or replies) for a specific keyword. If the word is not found, add it to the subject.

These samples contains the basic code for working with all items in a selected folder or selected items in a folder.

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  

Use an Outlook macro to create a list of users in the Exchange Global Address List or a list of member of a distribution group in the GAL.

You can easily change the default form used for new items for any folder type except Mail folders. Although the screenshots are for contacts, the steps are the same for Calendar & Tasks. Right click on the folder name and choose Properties. Then select the new form from the General tab, When posting to this  

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.

How to copy appointments from several Outlook calendars to print as one calendar. Includes code specific to Exchange server accounts that works with Resource calendars as well as other user's calendars.

A user wanted to know how to remove [External] from the subject of incoming messages. My company recently instituted the policy that puts the [EXTERNAL] tag in every subject when an email is received from outside the organization. When it's only one email, it's not really an issue. However, when it turns into a thread