Stopping Outlook alerts from Excel when emailing

[Steven Cheng]

I can't for the life of me remember how I did it.

i have one file which will email several files out to different email
addresses, however, the annoying prompt from Outlook keeps popping up warning
about viruses.

how do i suppress this again. i don't believe it was as simple as turning
the application.displayalerts to false.

 

[Tausif]

HI,

I think 1 way to bypass the prompt is to lower your macro security level in
Outlook (tools > macros > security..) to either medium or low. (Obvoiusly not
recommended)

The other solution I think is to self sign your macro with a digital
certificate. This is done via Tools > macros > visual basic editor, then in
here: tools > digital signature. Find more details in this link
http://msdn.microsoft.com/en-us/library/aa155754(office.10).aspx

You can also outlook redemption which is free.
http://www.dimastr.com/redemption/

HTH,

 

[Ron de Bruin]

For other options see
http://www.rondebruin.nl/mail/prevent.htm

 

[Tausif]

Hi Ron,

Great set of CDO examples on your site. Very insightful.

Cheers,