E-mailing message

[grnzbra]

I am using the send object command to send a series of e-mails. The code loops through a table of message text and e-mail addresses to fill in the parameters of the command. My problem is that the code runs out ahead of the sending of the e-mails. Is there any command that can stop the code until the system is ready to process the next message? I am currently using a timer but would like to use something a little more efficient.

 

[simongallop]

change the command to view the email then send it yourself, that way the code pauses until the email has been sent

 

[grnzbra]

Would that allow me to walk away and come back 15 minutes later and have all 200 or so e-mail sent?

 

[Xenix]

You could just make a software delay loop inside the funtion e.g.

Sub MyDelayMacro
For iCount = 1 to 999999
Next iCount
End Sub

or maybe better for you:

Sub MyMainMacro()
' Pause for 15 seconds.
Application.OnTime When:=Now + TimeValue("00:00:15"), _
Name:="MyDelayMacro"
End Sub

Hope this helps you
Mike