outlook macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

matt - 30 Jan 2006 12:54 GMT

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

Reply to this Message

Sue Mosher [MVP-Outlook] - 30 Jan 2006 13:30 GMT

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.

Signature

Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> 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
[quoted text clipped - 6 lines]
> cheers in advance
> Matthew

Reply to this Message