Send email outlook from Excel text spacing new lines

[dwilson38550m]

Hi, I have a macro to send a pre-written message in the body of the email. I am using .body in the script in VBA....does anyone know how to create new lines and paragraphs in the text so it does not appear as one big long sentence. So I want it to appear in the email as


Hi

Please find attached......


If you have any queries....

Regards
X xxxx


Thanks

 

[paulxmw]

The way i have done this is to create a sheet called Text then typed the text i want in the email on every other line and added the code below into the VBA you could add as many lines as you want, the reason mine starts at B6 is because lines 1-5 are been used for other things on the text sheet

'Email message body
This should read with ab backwards arrow before body but it wont post
Body = "BODY style=font-size:11pt;font-family:Arial>" & _
Sheets("Text").Range("B6").Value & "
" & _
Sheets("Text").Range("B7").Value & "
" & _
Sheets("Text").Range("B8").Value & "
" & _
Sheets("Text").Range("B9").Value & "
" & _
Sheets("Text").Range("B10").Value & "
" & _
Sheets("Text").Range("B11").Value & "
" & _
Sheets("Text").Range("B12").Value & "


"

Hope this helps