VBA Code Samples

The following code works in Outlook 2000 and up. It 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  

How to keep the name of an attachment in a message after using VBA to remove the attachment.

How to use VBA to create a list of your color categories then merge or restore the list to another account using a second macro.

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

I get quite a few complaints from people who say their fonts are tiny (or huge) or the font used for the reply shrinks yet Microsoft Outlook shows they are using a normal size font (such as 10 or 12 pt). I'll show you how to fix it. I also have a macro that will set the zoom level for you.

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

Use an Excel macro to create appointments in subcalendars in Outlook. To use, type the appointment data, including the calendar name, into the spreadsheet then run the macro. The macro creates appointments in the correct calendar folder.

How to use a Microsoft account address with a Outlook.com account to sync appointments and contact with other computers or smartphones. This method works with the Outlook Connector in Outlook 2003, Outlook 2007, and Outlook 2010 and Outlook 2013's EAS account type.

How to add a file number to the subject line of an Outlook message using VBA. (Sample macro included.)

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 save attachments and then open the attachments without opening Windows Explorer to find the attachment.

How to remove attachments from selected messages in Microsoft Outlook's Sent Items folder using VBA.

If you want to save messages in a universal format and want the attachments stay with the document, you need to convert the message to RTF format then save the message in *.doc format. . While you can do this in Outlook, it takes several steps. Using VBA to save messages to your hard drive in *.doc format takes just seconds.

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  

Use VBA to select multiple calendars in overlay mode. Can deselect iCloud calendars using this code. Code Sample included.