Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Question on using Ron de Bruin's Excel menu sample code | Excel Programming | |||
Questions on Ron de Bruin's Excel Email Macro | Excel Programming | |||
Missing dll to work with Ron de Bruin's code | Excel Programming | |||
Code to Email with UNC in subject line | Excel Programming |