Emailing by VBA program using Outlook

[Guest]

A friend showed me how to build a program to send emails to people listed in
a database. We have a bunch of monthly reports, all with the same name, all
going to the same people in 21 counties, every month. The program works
fine, but when Access sends the message to Outlook, every message requires
about 10 seconds while the green line goes across the bottom and then I have
to hit the YES button. Well, when you have 210 emails, that take a few
minutes.

Is there any way to disable the YES NO CANCEL?

 

[Sue Mosher [MVP-Outlook]]

See http://www.outlookcode.com/d/sec.htm

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

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