Sending email using VBA - One Final Piece

I've got the program working fine, it sends email when it needs to and
all and it sends it with the proper subject, body and to the proper
email address.

The one last thing is that every time it needs to send an email, I get
an email form that just stays there waiting for someone to press the
"Send" button.

Is there any way to programatically get around this? I may be sending
hundreds of emails at a time and I'd rather not have to click on the
button for each one. I tried SetWarnings and that didn't do it. Any
help would be appreciated.

re: Sending email using VBA - One Final Piece

I should add I'm using SendObject, my line of code is:

DoCmd.SendObject , , acFormatTXT, stTo, , , stSubject, stText, -1

re: Sending email using VBA - One Final Piece

SOLVED. Duh. I needed to change the -1 at the end of the line to a 0.

I know, I know... RTFM!!

ManningFan wrote:

re: Sending email using VBA - One Final Piece

ManningFan wrote:
At 20+ apps per month, one hardly has the time. 8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me

re: Sending email using VBA - One Final Piece

Tell me 'bout it, Timmy... My boss rides me harder than Pam Anderson's
vibrator.

Tim Marshall wrote:

re: Sending email using VBA - One Final Piece

ManningFan wrote:
8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me