Access VBA send html body email question 1

vamoose · Aug 21, 2008

I am using Access 2003 VBA to generate an Outlook 2007 email which is working fine. In the .HtmlBody section I would like to have 3 lines of text instead of just one which is what I am getting now. So my question is how to create a carriage return in the .HtmlBody section of the email text. Thank you.

With OutMail
.To = mail_to_list
.CC = ""
.BCC = ""
.Subject = "Varnish Tank Status, Philips EMAG, Juarez"
.HtmlBody = "<html>Raw varnish level: " & raw_gallons & " gallons. Day tank varnish level: " & day_gallons & " gallons. Last Updated: " & lastupdateraw & "</html>"
.Send
End With

traingamer · Aug 22, 2008

You can put html breaks (<br>) between the lines or any of a number of other html elements like paragraphs, divs, etc.

e.g.

Code:

.HtmlBody = "<html>Raw varnish level: " & raw_gallons & " gallons.[blue]<br>[/blue] Day tank varnish level: " & day_gallons & " gallons.[blue]<br>[/blue] Last Updated: " & lastupdateraw & "</html>"

or

Code:

        .HtmlBody = "<html><p>Raw varnish level: " & raw_gallons & " gallons. 
<p>Day tank varnish level: " & day_gallons & " gallons. 
<p>Last Updated: " & lastupdateraw & "</html>"

etc.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

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!

Access VBA send html body email question 1

vamoose

Programmer

traingamer

Programmer

Similar threads

Part and Inventory Search

Sponsor