 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / August 2006Using SendObject
I'm using this DoCmd.SendObject , , , "myemail@dot.com", , , "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 > I'm using this > [quoted text clipped - 7 lines] > > 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).  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com > 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). 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). 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 >> 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 [quoted text clipped - 7 lines] > outputformat as acFormatHTML but the email opens up as text. Does > anyone know? 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. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.