Bypassing Outlook's security message when using Excel macro to send mail?

[chuckles1066]

I doubt there is although, given Microsoft's propensity to have more security holes in their products than a piece of Swiss cheese, I live in hope.

Thanks to the great advice I've received here, I've managed to cobble together a macro which completely automates an entire process that used to take four hours.

Until it comes to the email bit.

Whenever an email is autosent from Excel, Outlook protests about the fact and holds things up for five seconds at a time.

Is there a way to bypass this "security feature"?

 

[VoG]

Try this http://www.rondebruin.nl/mail/prevent.htm

 

[chuckles1066]

Thanks for that, I'll try the last one on Monday morning.

(Company network, 3rd party software can't be installed)