Forum Discussion
karenlorr_uk
Mar 08, 2022Copper Contributor
Send email only after previous
I would like to send 2 emails to someone. How would I force the sending of the 2nd email only after the previous has been sent. I have tried a Yes/No msgbox but the 2nd email still opens in the b...
arnel_gp
Mar 08, 2022Iron Contributor
add a Timer loop between each SendObject.
Example:
'First email
DoCmd.SendObject....
Dim t
t = Timer + .5
Do Until timer > t
DoEvents
Loop
'Second email
DoCmd.SendObject...
Example:
'First email
DoCmd.SendObject....
Dim t
t = Timer + .5
Do Until timer > t
DoEvents
Loop
'Second email
DoCmd.SendObject...