Macro Magic – Changing the location of the save sent message folder

When you are sending a message, you have the ability via the Options dialog (from the View menu) to change the folder location of where Outlook stores a copy of the message you are sending. This defaults to the Sent Messages folder for the default store. However, if you pick a folder from somewhere other than the default store (i.e. another loaded .PST, etc.), you get the following error:

Save Sent Message error

All is not lost though! You CAN change this with a macro. The code below could be of use to anyone who loads multiple stores associated with different e-mail accounts, and likes to store messages sent using those accounts in a folder for that store. If you have more than one location where you would like to store these messages, create one macro for each folder.

Simply modify the code below to change the IDs for the Folder and the Store where it resides. If you’re quite familiar with Outlook VBA, its fairly straightforward to find the IDs for a particular folder by walking through the Folders collections in the related InfoStore object. An easier alternative is to use OutlookSpy to pry the value from a nice GUI.

When you’re ready, create a custom button on your toolbar somewhere (with the new mail message window open) and map it to the macro that you just created. Before you send the message, click the button to change the folder, and presto! A copy of the sent message will now be stored in the folder you specified.

Eric Legault

Microsoft Outlook MVP (15 yrs). Author: Microsoft Office 2013 Pro Step By Step. Consultant/speaker/Outlook add-in builder/SharePoint pioneer. Guitarist: Maiden Canada (Iron Maiden tribute band)

You may also like...

%d bloggers like this: