Inserting carriage return in Outlook HTML from Access VBA 1

[merlynsdad]

I'm having a problem inserting a carriage return in Outlook HTML being sent via Access VBA. Here's the pertinent line of code.

objMail.HTMLBody = "Ticket " & intTixNum & " has been entered into Ticket Tracker by " & strEmpName & " concerning " & strIssue & ". " & strSomestr & "  "

I understand chr(13) and chr(10) only work in text mode, but can't find the corresponding code to use in HTML. I need the break between the period after strIssue and strSomestr.

If the square peg won't fit in the round hole, sand off the corners.

 

[oharab]

You're using HTML email, so doesn't your string need to be in html?

objMail.HTMLBody = "Ticket " & intTixNum & " has been entered into Ticket Tracker by " & strEmpName & " concerning " & strIssue & ". <br />" & strSomestr & "  "

or

objMail.HTMLBody = "<p>Ticket " & intTixNum & " has been entered into Ticket Tracker by " & strEmpName & " concerning " & strIssue & ". </p><p>" & strSomestr & "</p> "

----------------------------------------------
Ben O'Hara

We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.

 

[merlynsdad]

That makes perfect sense, and it works perfectly. Thanks!

If the square peg won't fit in the round hole, sand off the corners.