The articles listed below contain VBA code samples. Additional code samples are listed at Developer Samples
Print Outlook Business Card Images
Use this macro to create and print a Microsoft Word document containing Outlook's business cards. The macro saves the card as a jpg image then inserts it into a Word document. Option Explicit Public Sub MergeContactPhoto() Dim currentExplorer As Explorer Dim Selection As Selection Dim oContact As ContactItem Dim obj As Object Dim filename As
Using Voting Buttons in Email
I had a few questions about Outlook's voting buttons this week. Several users wondered why the voting buttons weren't working on messages sent to addresses outside of the company. When you add voting buttons to an email, the message is sent using Rich Text Format (RTF). Because only Outlook can decode RTF messages, many Exchange
Add BCM Account name to Contact's Company field
A user decided the BCM was overkill for his needs and wanted to move his 5000 Business Contacts into Outlook Contacts before upgrading to Office 365. The only issue was keeping the contact associated with the Account name it was assigned to in BCM. The Company name field was suitable, but he needed to update
Accept or decline a meeting request then forward or copy it
Use a VBA macro in Outlook to save as an appointment or forward to another address before accepting or declining incoming meeting requests.
Mail Merge to Email using an Outlook Macro
Use an Outlook macro and a Word document containing merge fields to mail merge to email. You can even add an attachment to the message before sending.
Create an Appointment at the Contact's Address
How to create a new Outlook meeting with a selected contact. Includes a macro to include the contact's address in the Location field.
Using Windows environment variables in Outlook macros
How to use a Windows operating-system Environ property environment variable in a macro to set or get file paths, such as to save attachments or email to the user's My Documents folder. (Works with Word and Excel macros too.)
Macro to Print Outlook email attachments as they arrive
An updated macro to print Outlook email attachments as they arrive. This macro works with Outlook 2013 and older, 32 or 64-bit versions, with both 3 and 4 character Office file extensions.
Change Category when Task is marked Completed
Use the ItemChange event to run a macro when the value in a field is changed in Outlook. In this example, when a task is marked complete, the Category is updated.
Add the Age to a Birthday on Outlook's Calendar
How to add a person's current age to a birthday event on Outlook's Calendar using a macro.
Copy a Contact's Mailing Address
Use a macro to copy a Contact's name and mailing address block to use in another program.
Macro to Reply, ReplyAll, or Forward and File
Use a macro to file the original message by sender after responding.
Automatically Create Contacts
This is a run a script macro that creates a contact for each person who sends you an email message. To avoid "pollution" of your contacts folder, the contacts are added to a subfolder of Contacts, called AutoCreated. Sub CreateContacts(oMail As Outlook.MailItem) Dim oNS As Outlook.NameSpace Dim folContacts As Outlook.MAPIFolder Dim colItems As Outlook.Items Dim
Merge to email using only Outlook
How to mail merge from Contacts to Outlook email directly, without using Microsoft Word, by inserting contact data into an email message, merge style.
Create Tasks Due Dates using a macro or custom form
Tasks is one Outlook feature that raises the ire of many users. Some users want the ability to create a task with a due date, but in the Outlook world, tasks can have reminders fire at any time, but they are really due until the end of the workday. If someone needs a task completed