VBA HTML email formatting

[TheWennerWoman]

I have a text box on a sheet which is the body of an email that gets generated.

It's formatted properly (ALT + ENTER to create new paragraphs) and the emails look fine.

I've been asked to include a hyperlink in the body so

Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
    With OutMail
        .SentOnBehalfOfName = Email_address_from
        .To = Sheet2.Cells(i, 4).Value
        .subject = subject
        .body = body '<<<<<< changed this to .HTMLbody
        .Send
    End With

However, the email now loses all paragraphs and just displays as several sentences strung together.

How do I get .HTMLbody to recognise paragraphs?

Thanks in advance as always.

 

[Micron]

Use pure html for the body text and you should have no problem. A new paragraph tag is <P>.
W3 schools has lots of info on writing html. They push cascading style sheets these days, but you should be able to find plenty of html examples. You can even test your code on their site before implementing it.

 

[Micron]

I just noticed your posted code uses .body but you will need to use .HtmlBody

Thanks for the recognition & I hope you get it working!