Clive,

The best thing I have found that works with all the newest security patches
applied is called Outlook Redemption. It's a dll that you need to register
on your machine, but circumvents the security warning.

http://www.dimastr.com/redemption/home.htm

Robin Hammond
www.enhanceddatasystems.com

"ccarmock" wrote in
message ...

I think it is possible to write some VB to send an email from within
Excel. However is there any way to stop Outlook generating the dire
warnings about a program is trying to email.

No I'm not trying to write a mass mailing worm! I need to allow this
functionality on two PCs. I did wonder if the VB was digitally signed
can that certificate be imported into Outlook so that there is in
effect a trust?

Basically I need the ability for an email to go out if a trigger event
occurs in Excel.

I wonder if anyone can offer a suggestion?


Regards

Clive


--
ccarmock
------------------------------------------------------------------------
ccarmock's Profile:
http://www.excelforum.com/member.php...o&userid=27670
View this thread: http://www.excelforum.com/showthread...hreadid=539461