Using Access 2003 to Send Outlook Emails

  • Thread starter Thread starter bobalston9
  • Start date Start date
B

bobalston9

I am using the Outlook library to send emails from Access. I have
Outlook open and run a program to respond yes to the security question
(Express click Yes).

It seems to take about 5 seconds for each email to get sent.

Does this seem like the normal amount of time for others who do this?

Any tricks to speed it up?

Bob
 
Yes, executing a Send statement from an external program requires a 5-second delay. See http://www.outlookcode.com/d/sec.htm for your options with regard to the "object model guard" security in Outlook 2000 SP2 and later versions.

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Yes. All that program does is "click" the dialog that the Outlook security feature puts up.

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
When you post in an Outlook forum, you really must clarify what CDO you're talking about. Paul's approach is to use CDO for Windows, which has always been a solution as long as you have an SMTP server you can send through. Note that such messages do not go through Outlook at all.

Great article, BTW. Thanks for pointing it out.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

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