VBA Code Samples

How to use a Microsoft account address with a Outlook.com account to sync appointments and contact with other computers or smartphones. This method works with the Outlook Connector in Outlook 2003, Outlook 2007, and Outlook 2010 and Outlook 2013's EAS account type.

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.

A user wanted to know how to create an AND rule: If the subject contains outlook AND word, do something For example: "outlook AND word" to match on a Subject line of "Mail merge Outlook and Word", but not "Outlook Teams Meeting" While Outlook Rules don't support AND within a rule, you can make it  

This macro uses Adobe Acrobat, not Reader or other PDF applications. This run a script macro will open an attached PDF file, look for a keyword and if found, forward the attachment. If the message you are forwarding contains external content, you may need to respond to a security dialog. In this case, you will  

Martin asked how to change the font in the Notes field only in Contacts, but not in the other Outlook items types. Easy: use stationery for your email messages, or VBA to change the font for certain item types. I'll show you how.

Add categories and change to Tentative the Focus Time appointments created by the Insights feature of Office 365 Exchange Online.

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

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

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  

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

Note: You should only use a self-signed certificate for personal use. To increase your level of security and eliminate annoying dialogs, you should only used signed macros with Microsoft Outlook (or other Office applications).  To make it easier for users who write macros for their own use, Microsoft provides an application you can use to create