outlook macro

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Security 2
How to avoid an Outlook message that pops up 1
Automatically Send e-mail prompt 6
Outlook Security Messages when Sending Email from Code 1
Access Automatically Send a notification email once a record is added 0
How do I identify if it's a meeting request in this outlook macro? 1
Outlook Macro - Help Required 0
Can I avoid the warning when I send mail from Excel 1

Top