automate the process of sending emails from MS Access
Posted on 2012-09-13
I would like to be able to send colleagues an email reminder about their annual review.
I have set up the timer routine and selected the appropriate people to receive the email but when i run my routine which uses
DoCmd.SendObject , , acFormatTXT, varTo, , , stSubject, stText, -1
it generates the first email but then waits until I manually press the send button before it generates the next email.
I wanted to be able to run this overnight so is there any way to bypass the manual "send" and fully automate the process?