outlook macro

[matt]

is it possible to write an outlook macro that can connect to an access
database, get data from some tables (including email addresses) and then
send emails automatically - without getting any security warnings?

the reason i ask is that when i try to send email from access, i get the
"A program is trying to send an email on your behalf....." security message
and you have to wait to press the Yes button.

cheers in advance
Matthew

 

[Sue Mosher [MVP-Outlook]]

Yes, if you're using Outlook 2003. An Outlook 2003 VBA macro that derives all its objects from the intrinsic Application object will not trigger security prompts.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers