VBA Code Samples

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

This simple macro uses a Task to open a web address in Internet Explorer when a reminder fires.

How to insert or change an Outlook signature using a VBA macro.

When customizing an Outlook appointment or meeting form, there are a few issues you need to be aware of, plus a few tips for customization ideas.

Remove a signature from a message using a VBA macro.

Outlook 2010 added a feature to check for a blank subject but users of older versions of Outlook need to use a macro to display a warning before sending a message with a blank subject line.

An Outlook user saw my macro that adds attachments names in the reply and asked about a macro that will add the attachment names to the message body before sending a message.

How to block junk mail and spam sent from the new top-level domains in Outlook.

Sometimes we get some interesting questions and the solution, while not useful to everyone, is worth mentioning. This is one of those questions. I must use the BCC most of the time because of confidentiality reasons. I have made mistakes a couple of times when I entered the email addresses of more than one recipient  

I'm often asked how to configure Microsoft Outlook to always reply using HTML format. Outlook doesn't support this but you can use VBA.

Use a macro to quickly add the sender of an email to a Contact Group.

Sub DateStampTop() Dim objApp As Outlook.Application Dim Item As Object Set objApp = Application Set Item = objApp.ActiveInspector.CurrentItem Item.Body = Format(Now(), "MMM dd, yyyy h:mm AM/PM") & vbCrLf & vbCrLf & Item.Body End Sub Sub DateStampCursor() Dim objApp As Outlook.Application Dim Item As Object Dim objWord As Object 'Word.Application Dim objDoc As Object 'Word.Document Dim  

Use a macro to file Outlook Email in folders by sender's name. Or file your email by received date.

This code sample demonstrates how to use the contents of a text file to populate a ListBox. This works for ComboBoxes and TextBoxes. A client adds keywords to message subjects so it's easier to find the messages later but had a problem: if he misspelled a keyword or used a slightly different keyword, he might not find the message. My solution is a macro that lists keywords to choose from. He can select one or more keywords then click OK to add the keyword(s) to the subject.

How to create an Outlook rules using wildcards.