How to get e new line in html email (Ron De Bruin's code)


Mark Stephens


Everything is fine until I want a html signature at which time the code
stops recognising the new line instruction.

Here's the relvant bits of the code the first works fine the second has the
problem, both codes are the same except the line:

.Body = strbody & vbNewLine & vbNewLine & Signature

changes to

.HTMLBody = strbody & vbNewLine & vbNewLine & Signature

Here's the code:

psCustomerName = "John Smith"

strbody = "Dear " & psCustomerName & "," & vbNewLine & vbNewLine & _
"This is line 1" & vbNewLine & _
"This is line 2" & vbNewLine & _
"This is line 3" & vbNewLine & _
"This is line 4":

With OutMail
.Body = strbody & vbNewLine & vbNewLine & Signature

The plain text code outputs an email that looks like:

Dear John Smith,
This is line 1
This is line 2
This is line 3
This is line 4

The HTML code outputs an email that looks like:

Dear Wilddan, This is line 1 This is line 2 This is line 3 This is line 4


Can anyone tell me how I can find some instructions on how to format a html
email so it comes out how I want?

Thanks for your help, Mark


Ritwik Shukla

Use & vbCrLf for new line...
For example

If you wana write:

Then the code is
"Regards," & vbCrLf & _
And if its



Then the code is

Ronald R. Dodge, Jr.

Just as Ritwik said, use the vbCRLF in place of vbNewLine


If you go back to the old manual type writer days, New Line (aka Line Feed
hence the LF part of the constant) meant only going down a line, it didn't
take the point of the next strike to be on the left side of the page. The
term they used to describe this action was "Carriage Return", hence the CR
part of the constant.

Carriage return doesn't change the line just like line feed doesn't change
the relative position of the cursor from the left edge, so it takes both to
get the effect you are looking for.


Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000

Mark Stephens

Thanks very much for your input guys but unfortunately it doesn't woek, I
still get no line underneath the Dear x,

Any other ideas?

Regards, Mark

Ron de Bruin

VbNewLine is not working in HTML

Use this <br>

strbody = "<H3><B>Dear Customer</B></H3>" & _
"Please visit this website to download the new version.<br>" & _
"Let me know if you have problems.<br>" & _
"<A HREF="""">Ron's Excel Page</A>" & _
"<br><br><B>Thank you</B>"

Mark Stephens

Thanks Ron, works a treat, now only one last (annoyingly small) hurdle to
overcome (isn't there always?!)...

Dear x,

Thank you for the brief conversation last night.

The first sentence is in calibri, the Dear x line in times new roman (don't
know why on earth it should be ... calibri is my default font)

I guess I need to use html body like i did for the signature but it seems a
lot big change to solve such a little problem, any ideas?

Thanks and regards, Mark


Add HTML font tags to your code:

<font face="Times Roman">asdf</font>

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question