"Nathan Strom" wrote in message
om...
"Damien McBain" wrote in message
...
My excel VBA sends some files it's just created to a number of e-mail
addresses specified in one of the worksheets.

I understand why outlook warns before sending the mail from excel and
other
applications, but can I stop the other message re trying to access
addresses
from my adress book? The address book doen't really come into play, I
have
addresses in the lists. I'm using exchange (not SMTP) so I don't think I
can
use CDO.

Please see: http://www.slipstick.com/outlook/esecup.htm#autosec

In short, there's no way to do it with VBA or Excel alone.

If all your users are on Exchange, you can use the administrative
options to disable the prompts; see:
http://www.slipstick.com/outlook/esecup/admin.htm.

Your other option is Outlook Redemption, a DLL addin which will allow
you to easily modify your code to bypass Outlook's security prompts:
http://www.dimastr.com/redemption/. There's a free version to use if
your code is non-commercial, and it's relatively inexpensive to
license a distributable version for commercial use. I'll recommend
this option, since it's the one I use. :)

Set Redemption = very nice

thanks Nathan

Damo