Code Samples

This category contains code samples put together to solve a specific user’s problem. The pages may not have detailed instructions for use.

Macro to Export Outlook Fields to Excel

Macro to Export Outlook Fields to Excel

Use a macro to write Outlook values to an Excel spreadsheet.

Macro to Copy an Outlook message to another folder

Macro to Copy an Outlook message to another folder

A user had this question: I want to do the following: 1. Copy a message from one public folder to another public folder 2. Mark the original message as read 3. Mark the original Complete 4. Add a Category to it A Quick Step will categorize the e-mail first (it has a higher priority) and  

Import meetings from a CSV or XLSX file

Import meetings from a CSV or XLSX file

Use a macro to import data from a CSV or Excel xlsx file to create meeting requests or appointments.

Use VBA to move messages with attachments

Use VBA to move messages with attachments

Use a run a script rule or an ItemAdd macro to look for messages with attachments. When the attachment is a specific file type, do something with the message.

How to use Windows filepaths in a macro

How to use Windows filepaths in a macro

How to choose the file path when you save an Outlook attachment or a message using a VBA macro.

Save selected email message as .msg file

Save selected email message as .msg file

A VBA code sample to save one or more selected messages to your My Documents folder as .msg files, using the received date and time as the filename.

Selectively change message format when replying

Selectively change message format when replying

How to change the message format on selected messages when replying. You can also use a Run a Script rule to change the message format as messages arrive.

Copy attachment names when replying

Copy attachment names when replying

Use a macro to copy attachment names from the original message to the reply or reply all in HTML or plain text messages.

Process items in a shared mailbox

Process items in a shared mailbox

You can't run rules on a shared mailbox and client-side rules in a mailbox won't run if Outlook is not open. Use an ItemAdd macro to watch the folder for new items.

Foward a message and CC the original recipients

Foward a message and CC the original recipients

A visitor to the Microsoft Answers forum asked about forwarding a message and automatically CCing it to the original recipients.