Microsoft Outlook Macro – Auto Bcc and Typo Catcher
A number of years ago a boss asked me if there was a way to get Outlook to automagically bcc himself to an email. So I did what any wanna be coder does and searched google for some code that someone else had posted. I didn’t find anything that completely did what I wanted it to do, but between some time on Stack Overflow and other searches I was able to hack together some VBA code that will not only bcc but will also give you a prompt to make sure you want to to bcc (so it doesn’t have to do it for every email) – you can even hit cancel before you send the email in case you spot a typo, which comes in handy from time to time and is a big reason why I still use it today.
Later on I was asked to make this work with multiple email addresses managed in Outlook – so now it can tell what email you’re sending from. Pretty nifty stuff!
Installing this is super simple. You’ll have to enable the Developer ribbon and open up the Visual Basic Editor (do a quick google search if you aren’t sure how to do that – “How to enable developer ribbon in Outlook”). Once in there, expand “Microsoft Outlook Objects” and then double click on ‘ThisOutlookSession’. Then copy and past the code below and hit Save. You have to lessen the macro security on Outlook for this to work.
Click here for a txt file with the code. Then simply copy and paste into VBA, save, close, and restart Outlook.
If you’re a fan of hotkeys, you can hit Ctrl + Enter to send an email. Then when the prompt comes up, Hit ‘Enter’ for the bcc option, ‘n’ to send and not BCC, or scroll over to Cancel if you catch a typo or aren’t ready to send it yet.
There are two main configuration options.
Option #1: you can set it to always BCC the same email address. This would be useful if you use a CRM that has a private email address for you to auto-catalogue your emails. If you use this option, you’ll probably want to change the line that starts with ‘Msg =’ by deleting this part “at ‘ & StrBcc &’ “.
Option #2: is the default. It will look at the email address you are sending from and use that. You’ll know it is the right address because the message prompt will show you which email address it will use for the bcc.
Toggling between the two options is as simple as adding and removing a leading apostrophe in that line of code.
You should also be aware that this macro does not always work when you use the ‘Send as attachment’ option from other Office programs. If someone knows how to fix that, let me know!
Ok, that’s it. Enjoy!