View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ritwik Shukla[_2_] Ritwik Shukla[_2_] is offline
external usenet poster
 
Posts: 6
Default How to get e new line in html email (Ron De Bruin's code)

Use & vbCrLf for new line...
For example

If you wana write:

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

Regards

Ritwik

Then the code is
------------------------
"Regards," & vbCrLf & _
vbCrLf & _
"Ritwik"
------------------------







"Mark Stephens" wrote:

Hi,

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

Regards,



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





Regards,