Using Access 2003 to Send Outlook Emails

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
 
S

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
 
S

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
 
S

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
 

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

Top