VBA Code Samples

The following is the Save Attachment code sample from Teach Yourself Outlook 2003 in 24 Hours. (It works in current versions.) Frank modified the code to break it into a single call for each mail item so you can use it with a rule to filter incoming mail. Augusto modified Frank's code "in order to avoid  

How to move or import appointments from an Outlook calendar into a Group Calendar.

A user had a request: an automated way of telling people a meeting full. It's not an unusual request, 3 or 4 people ask me how to do this each year. This time it sounded like a fun project to do. I am in charge of organizing meetings for my company (150+ people). However, depending  

I'm going to begin this by saying that I really think it's time to find another solution for journaling. I have no idea how many more versions we'll see before Microsoft rips Journal's heart out. It's time to move on to something that is going to be around longer. On the other hand, it's possible  

How to create a macro that reads values from an Excel worksheet and sends a mail merge, replacing unique values in an Outlook template with values in the worksheet and send the message From an address in the worksheet.

How to hide extra Contact folders, left from previously linking contact sources with Outlook.com accounts, so they aren't visible in Outlook or on smartphones.

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.

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  

Another entry in my Lazy Programmer Series, a macro for Outlook users who want to schedule a message to send later. This macro is triggered by a reminder and sends a message, composed from the appointment's subject line and body.

Use this code to send a new message using the address the selected message was sent to as the From account. This code is for people who use an account such as Gmail or Hotmail to collect mail from other accounts. Outlook will always reply using the account that downloaded the message, this code selects the send using account based on the address the message was sent to.

Use an Outlook macro to open every hyperlink in the selected email message. A version of the macro will open hyperlinks in every message in the selected folder.

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

Outlook doesn't have a built in method you can use to automatically include yourself (or other email address) in the BCC field when you send a new message. You can use Rules Wizard to CC and address but not to send a BCC.

How to automatically create tasks for message you send using a VBA macro.

Option Explicit Private objNS As Outlook.NameSpace Private WithEvents objItems As Outlook.Items Private Sub Application_Startup() Dim objWatchFolder As Outlook.Folder Set objNS = Application.GetNamespace("MAPI") 'Set the folder and items to watch: Set objWatchFolder = objNS.GetDefaultFolder(olFolderInbox) Set objItems = objWatchFolder.Items Set objWatchFolder = Nothing End Sub Private Sub objItems_ItemAdd(ByVal Item As Object) Dim propertyAccessor As Outlook.propertyAccessor Set propertyAccessor