New line in macro message body vba

[lokeshsu]

Hi all,

I am using a excel macro to send message from excel and i have the code to send the mail, but the body of the mail is coming in a single line but i need to send it in different lines, how to do that.

Thanks
Lokesh

 

[Jon von der Heyden]

Break your string down with vbCrLf

strBody = "Hello" & vbCrLf & "This is on a new line"

.Body = strBody

 

[lokeshsu]

Break your string down with vbCrLf

strBody = "Hello" & vbCrLf & "This is on a new line"

.Body = strBody

This is not working i tried this in the code

With OutMail        .To = "email@email.com"
        .BCC = ""
        .Subject = " Report for Report for the last interval " & Range("C9").Value & "."
        .HTMLBody = "Hi All, " & vbCrLf & "Please Find Attached the RTM Report for Process for the last interval " & Range("C9").Value & "." & RangetoHTML(rng) & "Regards," & Chr(10) & "name" & Chr(10) & Chr(10)
        .Display
        .Send
    End With

above is the code which i used

 

[excelliot]

you can use

"<br/>"

with & after line where you want to have a new line since you are using

.htmlbody

.

Cheers!!

 

[jono19872006]

How can you ensure a new line if your .htmlbody comes from a defined cell where there are new lines actually in the text?