Advertisement

09.26.2007 at 11:12AM PDT, ID: 22854558
[x]
Attachment Details

Add delay of 30 seconds in VBA code

Asked by ScootterP in Access Coding/Macros

Tags: vba, delay, code, pause

I have a program for sending emails through Outlook I got from BlueClaw.  It sends out the same message to about 300 email addresses one at a time.  The problem is sometimes Outlook gets backed up and some message will not get sent.  What I would like to do is have a delay of about 30 to 60 seconds in the program after each email is sent.  Is there a way to put some code in the program to pause at some point and wait from 30 to 60 seconds?Start Free Trial
[+][-]09.26.2007 at 11:24AM PDT, ID: 19965370

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Access Coding/Macros
Tags: vba, delay, code, pause
Sign Up Now!
Solution Provided By: LSMConsulting
Participating Experts: 1
Solution Grade: A
 
 
[+][-]09.26.2007 at 11:26AM PDT, ID: 19965400

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.26.2007 at 01:50PM PDT, ID: 19966653

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628