Auto BCC for outgoing mails in outlook

Auto BCC for outgoing mails in outlook

Postby kawstov » Wed Nov 05, 2014 3:49 pm

Found the original content on - http://www.qdoscc.com/blog/auto-bcc-outlook-easy-code-create-macro-free

--------------------------------------------------------------------------------------------------------------

I came across an easy method to auto BCC from Outlook today. Should work with all versions of Outlook from 2003 to 2010 but below instructions relate to Outlook 2007. Menu options may vary slightly for other versions.

Use the following code:

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) Dim objMe As Recipient
Set objMe = Item.Recipients.Add("youremailaddress@whatever.com")
objMe.Type = olBCC
objMe.Resolve
Set objMe = Nothing
End Sub

Open Outlook and hit Alt+F11. Copy and paste the code and of course change the email address as approproate. Save and close the macro window.

Now it is necessary to 'Digitally Sign a Macro Project'.

In Windows go through the Start Menu and within the Microsoft Office folders open up 'Microsoft Office Tools'. Choose 'Digital Certificate for VBA Projects'. Type in an appropriate, descriptive name for your certificate in the 'Your certificate's name' field, and close.

In Outlook go to the Tools menu > Macros > Security and change the level to 'Warning for all macros' and press 'OK'.

Hit Alt+F11 again then navigate to Tools > Digital Signature. Click on 'choose' and select the digital signature that you created.

Restart Oulook.

Upon opening Outlook it will prompt you about the new Macro, so say Yes. And its done.
Cheers!
Kawstov
kawstov
Site Admin
 
Posts: 119
Joined: Tue May 28, 2013 10:51 pm

Return to Daily Scratch

Who is online

Users browsing this forum: No registered users and 1 guest

cron