Using Access 2003 to Send Outlook Emails

[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

 

[Sue Mosher [MVP-Outlook]]

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

 

[bobalston9]

Even when using Express Click Yes?

Bob

 

[bobalston9]

Even when using a routine like "express click Yes"??

bob

 

[Sue Mosher [MVP-Outlook]]

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

 

[bobalston9]

Any comments on use of CDO to send emails, bypassing Outlook?

See web page with info on using CDO to send emails from Win2k/winXP
pcs.

http://www.paulsadowski.com/WSH/cdo.htm

Bob

 

[Sue Mosher [MVP-Outlook]]

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