Using SendObject

  • Thread starter Thread starter Jesper
  • Start date Start date
J

Jesper

I'm using this

DoCmd.SendObject , , , "(e-mail address removed)", , , "subject line of email", "text
in email"

to send an email via outlook express. I'd like to loop it to send several
emails. If I do the first mail will open up BUT wait for me to send/close it
before opening the next. If there're 5 items in the loop can I open up 5
emails at one time?

Jesper
 
Jesper said:
I'm using this

DoCmd.SendObject , , , "(e-mail address removed)", , , "subject line of
email", "text in email"

to send an email via outlook express. I'd like to loop it to send
several emails. If I do the first mail will open up BUT wait for me
to send/close it before opening the next. If there're 5 items in the
loop can I open up 5 emails at one time?

Jesper
Click to expand...

Do you need to see and/or edit the message before sending? If not just set the
final argument to False and the message will not open on the screen at all. It
will just be sent. Otherwise I don't think you can open more than one at a time
using SendObject. You could by automating Outlook (but not Outlook Express).
 
Do you need to see and/or edit the message before sending? If not just
set the final argument to False and the message will not open on the
screen at all. It will just be sent. Otherwise I don't think you can
open more than one at a time using SendObject. You could by automating
Outlook (but not Outlook Express).
Click to expand...

This is great, I don't really need to see the email. I do still get a
message that "a program is trying to communicate" where I have to hit "send"
but it's tolerable. Can I get rid of that?
Thanks for your help. I didn't think of not seeing the emails before sending
them.

Jesper
 
Do you need to see and/or edit the message before sending? If not just
set the final argument to False and the message will not open on the
screen at all. It will just be sent. Otherwise I don't think you can
open more than one at a time using SendObject. You could by automating
Outlook (but not Outlook Express).
Click to expand...

It works pretty well now. I'm experimenting with using a html template, but
it doesn't seem to work.
I've assigned the name of the template as the last argument and the
outputformat as acFormatHTML but the email opens up as text. Does anyone
know?

Jesper
 
Jesper said:
It works pretty well now. I'm experimenting with using a html
template, but it doesn't seem to work.
I've assigned the name of the template as the last argument and the
outputformat as acFormatHTML but the email opens up as text. Does
anyone know?
Click to expand...

The output message body is always plain text. The OutputFormat argument
applies to the object being attached (if any), not the message itself.
If you want to send an HTML message, you'll have to automate Outlook or
some other program, and not use SendObject.
 
Back
Top