Auto BCC items I send with Outlook 2002 and Exchange 2003

I want to be able to auto BCC any message that I send within the domain to a collegue that I am training so that they can become fully informed on messages that I send. I would like all external mail to be excluded however as this is out of the scope of the training and impacts on my privacy.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David LeeCommented:
Greetings, jsulliva1957.

Outlook has no built-in mechanism for doing this.  You'd have to find a third-party product or script your own solution.  If you went the script route, then you need to be aware that accessing any address field, which this would have to do, is going to trigger Outlook's built-in security.  That means a dialog-box will pop up each time the script ran warning you that a program is accessing your mailbox and asking you for permission to allow it to continue.  There are ways around that, but they too require third-party controls/software.  Other possible, but not fully automatic solutions, would be to create a message template or a bit of script that'd create a message with your collegue already BBCd.  The difference would be that you'd have to click a different toolbar button, i.e. not the New button you click now, to create the message.  I can show how that's done if you want to use that solution.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jsulliva1957Author Commented:
Thanks BlueDevilFan

The last option looks to be the best one. I do not want to put you to any trouble in guiding me towards this solution, but if you have a reference or it is not too much trouble I would appreciate it


David LeeCommented:
Hi, Jim.

It's no problem.  This is very simple.  Here's the code for doing this.  Follow these instructions to set it up in Outlook.

1.  Start Outlook
2.  Click Tools->Macro->Visual Basic Editor
3.  If not already expanded, expand Modules and click on Module1
4.  Copy the code below and paste it into the right-hand pane of the VB editor window
5.  Edit the code as needed.  I included a comment wherever something needs to change.
6.  Click the diskette icon on the toolbar to save changes
7.  Close the VB Editor
8.  Click Tools->Macro->Security
9.  Set the Security Level to Medium
10.  Test the macro by clicking Tools->Macro->Macros and selecting AutoBCCMessage in the list of available macros.  A new message will appear onscreen with your collegue's address filled in on the BCC line.

Sub AutoBCCMessage()
    Dim olkMessage As Outlook.MailItem
    Set olkMessage = Application.CreateItem(olMailItem)
    'Change the email address on the following line
    olkMessage.BCC = ""
    Set olkMessage = Nothing
End Sub

Follow these instructions to create the toolbar button.
1.  Click View->Toolbars->Customize
2.  Click the Toolbars tab
3.  Click New
4.  Name the toolbar
5.  Click the Commands tab
6.  Under Categories click Macros
7.  Under Commands click and hold on the macro Project1.AutoBCCMessage, then drag it out and drop it on the new toolbar
8.  Dock the toolbar somewhere onscreen
9.  Any time you want to create a message with your collegue BCC'd all you have to do is click the toolbar button.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.