MAtrix - great script! this really worked perfectly

Hello Matrix:
I've tried and tried with Outlook 2007 running under Windows 7 (32 bit) to no avail. Your directions are clear and I've followed them to the letter, but emails go out without a bcc. Not sure if anything has changed since you wrote the macro.
Pete

hi frnds
i am unable to send the auto bcc with this macros
can someone help me pls

THIS WORKS - This is not going to make much sense, but where MS is concerned, will you be surprised?

IN ADDITION to creating the original suggested Macro, inside the same VBA session, select "Application" and then "Startup" from the dropdown. Some text will appear. Replace it with the following:

Private Sub Application_Startup()

MsgBox "Macros are enabled"

End Sub

I know. Some of you will immediately look at this code and say, "well that doesn't really do anything" But it does. Apparently, just telling Outlook that you want it to enable the running macros isn't always enough. Adding this, which triggers when the Outlook App is started, forces Outlook out of it's 'passive aggressive' nature.

If Macros are enabled, you'll simply see the message above ("Macros are Enabled") and move on. If they're not (which is likely the case for those of you having trouble running this), then you'll be prompted to "enable" or "disable". Click "enable", and you should be good to go.


Cheers,

AG

Well.. I have a suggestion myself, and it DOESN'T have to do with an additional script.

Just use the script mentions on the last page, and (in outlook 2007) (i dont have 2003 anymore.. sorry for that)

Go to Extra>Makro's> Security. There go to the tab "Makro Security" Also i have a Dutch office 2007, so don't mind my rubish english. Myself I have the setting on "No Secrurity for all makro's (NOT RECOMMENDED). Most people would say that Warnings for all makro's are recommended. But with all my makro's, that's just not worth it.

Next select OK, and reboot outlook.

This SHOULD enable the makro.. Ofcourse you CAN add the script in the post above this one, to make sure it all works.

Hope this helps!

Joost

I tried your path, but It's doesn't work

Thanks,
Sarinda

Hello,

first of all thanks for the great help found on this forum.
Second I would need some help regarding this macro. Two different solutions would help me:
- Either: I would want to change it in a way that reads the "From" field (as someone before me asked) and bcc's accordingly. I managed to do this by reading the smtpaccount, but I need the "From" account and not the Outlook smtp account

- Or: It would also be ok for me to create a new alternative send button which, if pressed, automatically enters the desired bcc address (and ideally also selects the "From" account)

Thank You

Sorry to resurrect such an old thread.

I added this code, and it works, even after closing an reopening Outlook 2007. The problem however, is that it CCs, instead of BCCing. Any ideas?

Hi
it works fine with me in outlook 2007.
i need to fwd my incoming mails also when it arrives outlook.
can u post the code for that pls ??

Outlook 2007 will block scripts/macros if they are not digitally signed. However, you can create your own digital signature and assign it to your script to prevent outlook from blocking it on startup.

From your start menu search for Digital Certificates and you will see a program called Digital Certificates for VBA projects, run that and create a name for your certificate.

Inside Outlook, open the code editor and your code open select the Tools menu and then Digital Signatures. Select your signature just created and click "click here to view certificate properties", click "Install Certificate", Click OK then OK again.

Save your script again and close the editor window and Outlook saving the VBA script if prompted.

Reopen Outlook and when prompted about the certificate select "Trust all documents from this publisher" - the publisher being the certificate you just created so dont worry

All done, enjoy.

my outlook2003 succeeded!
Writer, you forgot one thing!!! we should lowed the security level of macros and restart the outlook.

Select the menu "Tools |Macros |Security|

enjoy it!

I would strongly advise that any security especially macros is not lowered, its at a high level for a reason. If you refer to my instructions about creating a local self signed certificate then your macros settings can be left at their default levels.

Anyone reading this I would strongly advise leaving your macro security at its default level.

Softrix, Thank you! your config is very great to be called automatic BCC. i use this way to save all my company emails into gmail and never worry the data loss.

It works again with me, Outlook 2007. Thanks so much.

Your welcome