VBA Code Samples

Use PowerShell to search for Contacts with a value in a default or custom Contact field. While you can do a more complicated search within Outlook, you will need to use PowerShell (or VBA) if you want to search for a value in a custom field.

Forgetting appointments because you don't see the reminder? Let Outlook read the reminders to you! You can use the same method to read the subject of incoming mail.

If you need clickable links in a custom form, you can use VBScript code and a Label field or Command buttons to make clickable links.

Anyone who has a lot of meetings can understand this user's request: the ability to limit the number of meetings users can schedule with him each day by making Free/Busy appear busy.

How to use an Outlook macro to move or delete messages containing spammy keywords.

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.

How to use a macro to set up an Automatic reply (out of office reply) in Outlook on Windows desktop.

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

How to use VBA to send an email to someone when a new appointment is added to your Outlook calendar.

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

Use VBA to create a message to a Contact and defer delivery until the morning of their birthday. Use this technique to insert Outlook fields into a new message.

The following code saves the attachments from selected messages but does not delete the attachments from the message(s). This VBA code is based on the code sample from my Outlook book: Save and Delete Attachments. Use it if you want to save the attachment, add a link to the saved file, and delete the attachment  

A user wanted "a rule that will perform an action if I am the only one in the To box, even when there are others in the CC box". He also asked for a rule "that will perform an action if I am included in the To box but am not the only one in the To box".

Use the ItemChange event to run a macro when an Outlook item is changed. In this example, a task is created when the Quick Click Flag is clicked.

How to use an Outlook macro to move messages to a new folder or mailbox or to assign categories to the message round-robin style.