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
 

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
ThisOutlookSession macro problem 0
Need help with an automated email sender 0
How to avoid an Outlook message that pops up 1
Access Automatically Send a notification email once a record is added 0
Can I avoid the warning when I send mail from Excel 1
Automatically Send e-mail prompt 6
Outlook From Field Macro 4

Back
Top