VBA Code Samples

Tighter security on Outlook Custom forms breaks VBScript in the forms and some controls. Set a registry key to enable these features.

Use an Outlook macro to open every hyperlink in the selected email message. A version of the macro will open hyperlinks in every message in the selected folder.

How to replicate the Smart Lookup feature in Outlook using a different search engine.

How to sort email messages by domain. Although you can filter by domain simply by typing the domain name in the address field of the filter dialog, you need to use a macro to sort by domain.

Beginning with Outlook 2007 SP2, "Copy:" is added to the subject line of a meeting that is copied from a shared calendar. Workarounds are available.

Use Outlook VBA to remove the words Invitation and Updated invitation from meetings received from Gmail users.

How to create a macro that reads values from an Excel worksheet and sends a mail merge, replacing unique values in an Outlook template with values in the worksheet and send the message From an address in the worksheet.

Use an Application Startup macro to run Outlook's client side rules automatically.

How to get a list of Outlook Meeting attendees and their responses using VBA. This code sample gets the appointment details and attendees (along with their responses) and inserts it into a new Outlook message form, which you can print, send or copy the data fir use in other applications.

This code removes the reminder and categories and moves the appointment to a calendar in an archive folder or a subfolder under the calendar. I want to be able to do 3 things with just one click of a button: With a Calendar event selected, I want to: 1) Erase any Reminder (set Reminder to:  

Use VBA to watch for new appointments added to the calendar and copy them to a second calendar. This is useful if you are syncing with a second calendar and only want some items synced. New: watch for updates to the original appointment and change the copied appointment.

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

Use a macro to automatically add travel time to new meetings on your Outlook calendar.

How to use VBA to create a search folder for messages sent to and from the sender of the selected message. VBA code sample included.

I get quite a few complaints from people who say their fonts are tiny (or huge) or the font used for the reply shrinks yet Microsoft Outlook shows they are using a normal size font (such as 10 or 12 pt). I'll show you how to fix it. I also have a macro that will set the zoom level for you.