VBA Code Samples

When you use Microsoft Outlook 2010 or Outlook 2013 and have multiple accounts delivered to different *.pst files, Outlook doesn’t use the default account set in Account settings. Instead, it uses the account associated with the mailbox or *.pst file the folder you are viewing is stored in. This change in behavior doesn't work well when an IMAP is configured to be the default email account and you have a POP3 account delivered to the default pst file.

Categories and flags are not available in all of my folders in Microsoft Outlook. I can use categories and flags on mail in my POP3 account but categories are not available in my IMAP account and flags are limited to one flag, no reminder. Why? The IMAP protocol doesn't support the Category and Flag properties  

Another entry in my Lazy Programmer Series, a macro for Outlook users who want to schedule a message to send later. This macro is triggered by a reminder and sends a message, composed from the appointment's subject line and body.

New to Outlook 365: Remember Zoom Preferences. If the fonts in incoming messages are tiny (or huge), you may have a Zoom problems. I'll show you how to fix it. If you don't have an Office 365 subscription, I have a macro that will set the zoom level for you.

Outlook doesn't have a built in method you can use to automatically include yourself (or other email address) in the BCC field when you send a new message. You can use Rules Wizard to CC and address but not to send a BCC.

Create tasks from email as they arrive using a simple script and Rules Wizard. With a slight variation, you can create a task from the message you are reading in the reading pane. Complete instructions and ready-to-use code samples included.

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.

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.

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 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.

A VBA macro for classic Outlook to change the prefix on messages when the Reply and Forward prefixes are different, such as AW: instead of RE:. It can also be used to remove or change other prefixes, such as External:.

How to use a macro to reply to senders by inserting the text from a Word document as the message text. There is also a macro to send a new message with the contents of a Word document inserted.

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.

Use a macro to create a field in Outlook's Sent Items folder that displays the email addresses the message was sent to.

How to "do something" when you click the Reply, Reply All, or Forward button. Add a category, change the subject, add a recipient, add boilerplate text.