VBA Code Samples

Use Outlook's Rules Wizard and a Run a Script rule to autoaccept (or decline) meeting requests in Microsoft Outlook. Includes a version that checks your Free/Busy status before accepting (or declining).

Use an Outlook macro to save the selected message as a text file, or save the selected messages in a single text file.

How to use a Run a Script rule to have Microsoft Outlook automatically send a new email message using a template to new email addresses when a message meeting specific conditions arrives.

I have a macro that defers sending messages that are composed during a specific time period, such as during the overnight hours. After several users asked how to send responses or forward messages if the new messages arrived during the overnight hours, it's time to add macros for incoming messages as well. I would like  

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.

When you use rules to move sent messages, the sent items are not marked read when they are copied to other folders. You need to VBA to mark the messages read.

How to use Outlook's Rules Wizard Run a Script action to process messages using VBA. Using Run a Script rules will allow you to use actions not available in the Rules Wizard.

Use VBA to select multiple calendars in overlay mode. Can deselect iCloud calendars using this code. Code Sample included.

Outlook doesn't support creating shortcuts to folder on the Quick Access toolbar (QAT) or ribbon, but you can put macro on the QAT or ribbon that opens a folder.

Getting text out of a message body isn't as hard as it sounds, provided there is something in the body to search on. For example, if you are looking for a tracking code in an email and it's always identified as "Tracking code:" , you can use VB functions or RegEx to get the string.

How to create your own send to shortcut that uses your Outlook stationery and signature. Customize the shortcuts to include the email addresses and more.

How to use VBA to create and email a daily agenda with your upcoming appointments, each evening.

How to create a map or driving directions to one or more Outlook Contact's address or Meeting locations using VBA.

Using VBA, you can automatically create a series of Outlook tasks based on a task or appointment. You can create the tasks leading up to an appointment or task or following an appointment or task.

Use a macro to clean up duplicates messages in an Outlook folder.