How to send Mail in html format with SendObject? 1

jetspin · Dec 9, 2003

Hi.

I can send mail using the SendObject Method, but I cannot send mail in an html format. Can someone tell me what I'm missing? Thanks. Here is my code.

Dim strToWhom As String
Dim strMsgBody As String
Dim strMsgSubject As String

strToWhom = "vern@mydomain.com"
strMsgSubject = "Confirmation"
strMsgBody = "<HTML><HEAD><TITLE></TITLE></HEAD><BODY>" & vbCrLf
strMsgBody = strMsgBody & "Thank You for using our service! " & vbCrLf
strMsgBody = strMsgBody & "Vern 80 Main St Somewhere, TXC 11111 V. 111.111.2222 F.333.4444.4444" & vbCrLf
strMsgBody = strMsgBody & "</BODY></HTML>" & vbCrLf

DoCmd.SendObject , acSendNoObject, acFormatHTML, strToWhom, , , strMsgSubject, strMsgBody, True

ptpaton · Dec 9, 2003

Hi jetspin,

It's actually much simpler than that. Just build a macro tied to a command button.
1. Use the SendObject Action.
2. Specify the object type as report and the name as your created report
3. Specify Output Format as HTML
4. Specify default mailing header lines (if you want) such as addressee, sender, subject, etc. You can even put canned text in the email if you're sending the same thing over and over...
5. At Edit message, select "Yes" if you want to alter the email before you send it.

That's it. After hitting the button, Outlook will open with your new email, addressed to whoever you specify (I always send it to my office group) and with your report attached as an html document, which opens from OE.

Hope that helps!
Patrick

-Patrick

Nine times out of ten, the simplest solution is the best one.

jbento · Dec 9, 2003

Have you thought about sending the report as a snapshot. I do this using the below:

Dim strSubject as String

strSubject = Me.MyFormFieldName

DoCmd.SendObject acSendReport, "reportname", acFormatSNP, "To addressee here", "CC addressee here",, "Subject here", "Message here"

Maybe that can help,

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!

jetspin · Dec 9, 2003

Hi.

I still do not understand. I do not have a report to send.
I simply want to send the text body as a variable in the sendobject command line. I can do this as text, but I want to do it as HTML... If I have to do it as a report, then how do I write a report,,, what is its file name...etc..
Do I design a 1 page report that accepts an rec id number which I know how to do, but how do I do I run, print to a file, save it all in script?

It just so easy to do it all in one command line already as ascii text and there is a acFormatHTML....but this must only be for reports?

Any info would be appreciated. I've searched the web with mixed results about doing everything but something so simple.... just to run the sendobject command with a variable that containts the text in html format. Is that possible?

The only reason I want to use html is because I need to imbed a hyperlink. Its to send a customer a FedEx link of a tracking number. In ascii text, it gets truncated.

I will work on your suggestions in the mean time. Thanks!

jbento · Dec 10, 2003

Yes you would build a report, which you say you already know how to do. The rec ID field is the field to use to print a specific report.

Try this, and if you have questions, let me know.

Thanks,

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

How to send Mail in html format with SendObject? 1

jetspin

Programmer

ptpaton

IS-IT--Management

jbento

Technical User

jetspin

Programmer

jbento

Technical User

Similar threads

Part and Inventory Search

Sponsor