SendObject Question (Email)

[DiamondDust]

I want to the message text to have line breaks. For example, in the Message Text it Reads "Program Managers," I want to start a new line with "Please update your...". I basically do not want the whole message to word wrap.

DoCmd.SendObject , "", "", "[email@address]", "", "", "Health Management Database (HMDB) - Reminder Reporting Total", "Program Managers, Please update your reporting active member totals for you perspective vendor program(s). Thank you", False, ""

 

[dougcranston]

DiamondDust,

You should be able to create/dim a variable, and then concantenate the data you want to format it. Leverage off of CDONTS for sending email via SMTP. To create a body message with CR/LF where you want the lines to break, see the following.

Ex.

MyBody = "Attached is the monthly listing of store personnel" & VbCrLf
MyBody = MyBody & " in Excel format. Any questions, contact" & VbCrLf
MyBody = MyBody & "John Q Public at 800-555-5555" & VbCrLf

In the case of CDONTS I would then assign the BODY to this var to create the email body.

ex.
MyCDONTSMail.Body=MyBody

Creating a formatted document in an email from Microsoft Access

http://www.granite.ab.ca/access/emailformatted.htm

Check Google and look for "cdonts" to see other suggestions. Even if you are not using CDONTS or CDOSYS the approach should be the same with other

Hope this helps.
DougCranston

 

[DiamondDust]

Perfect, thank you dougcranston