outlook macro

  • Thread starter Thread starter matt
  • Start date Start date
M

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
 
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
 
Back
Top