Sending email using VBA - One Final Piece 
December 11th, 2006, 12:55 PM
| | | 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. | 
December 11th, 2006, 01:05 PM
| | | 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 | 
December 11th, 2006, 01:05 PM
| | | 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: Quote:
I should add I'm using SendObject, my line of code is:
>
DoCmd.SendObject , , acFormatTXT, stTo, , , stSubject, stText, -1
| | 
December 11th, 2006, 01:45 PM
| | | Re: Sending email using VBA - One Final Piece
ManningFan wrote: Quote:
I know, I know... RTFM!!
>
| 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 | 
December 11th, 2006, 02:05 PM
| | | 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: Quote:
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
| | 
December 11th, 2006, 06:45 PM
| | | Re: Sending email using VBA - One Final Piece
ManningFan wrote: Quote:
Tell me 'bout it, Timmy... My boss rides me harder than Pam Anderson's
vibrator.
| 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 | | Thread Tools | Search this Thread | | | |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts HTML code is Off | | | | | | What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 220,989 network members.
|