VBA Code Samples

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.

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.

How to use a macro to embed images in a folder into a new Outlook email message and send it. Send either one image per message or embed all images in the folder into one message.

Use a VBA macro to warn before deleting (or moving) a contact in classic Outlook.

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.

It's not hard to image this scenario: you create a custom view, everything is just the way you like it. Then you accidentally sort by a different column. Outlook saves the changes and your perfect view is ruined. In the early versions of Outlook, users were presented with a "Do you want to save changes?"  

A VBA macro for classic Outlook to remove "clutter appointments", such as delivery notification, focus time, or other old events I don't need on my calendar.

Addresses imported into the Contacts folder may not appear in the Address Book display.

How to use PowerShell to delete large attachments from all messages in a classic Outlook folder or all attachments from selected messages in any classic Outlook folder.

How to get a count of the messages you have selected in Outlook, using a macro or copy and paste.

How to remove attachments from selected messages in Microsoft Outlook's Sent Items folder using VBA.