I hate Outlook, but unfortunately one has to use it for work purposes, and since I’m partially responsible for supporting exchange, I tend to get users that whine about how Outlook works out-of-the-box.

By default, when using ‘Send As’ permissions to send email from an attached account, Outlook will save the sent item to your own personal mailbox. This is not desired by a lot of people. Sure, Outlook allows you to change where you want the Sent Item to be stored, but it does not work if you select another mailbox’s Sent Items folder. How annoying.

Fortunately, VBA comes to the rescue.

After a lot of googling, I managed to find some code that would do what I wanted, however it only worked for one additional mailbox, and you had to hardcode the mailbox name and “From” information inside the code. Unfortunately most of the users that work here regularly utilise more than one shared mailbox, so I set about to change the code so it would work dynamically. I’ve never coded in VBA before, and have barely touched VB before this (hello login vbscripts), so there are probably much better ways to achieve this.

To install the script, copy it into the clipboard, run Outlook, press ALT+F11 to open the macro editor, expand Project1, expand ‘Microsoft Office Outlook Objects’, and double click ‘ThisOutlookSession’.

Paste the code into the window on the right hand side. Save the macro, then restart Outlook.

You don’t need to change anything in the code, it just works.

Download VBA (Right-click, Save As)