need help formating the .body of an email send using vba and outlook.

[Abouya]

Hello,

I'm working on this excel spreadsheet vba to send active sheet as pdf and it works fine, except .body formating which doesn't look right.

Can someone please help me format it so it looks nicer? The "Hello" looks much bigger and "thanks," looks weird!

strbody = "Hello," & "<br>" & "<br>" & "PO Requisition #" & " " & Range("I5") & "<br>" & "Vendor: " & Range("C5") & "<br>" & "Total: $" & Range("J43") & "<br>" & "<br>" & "Please Find the file(s) attached for more details." & "<br>" & "<br><B>Thank you</B>"

Link to the screenshot: http://imgur.com/a/6zZH8

 

[Gasman]

I'd try inserting "<br>" before the Hello and see what that produces.?
You enclosed the Thank You in bold tags, and I cannot see what looks weird about it?

HTH

 

[Abouya]

I'd try inserting "<br>" before the Hello and see what that produces.?
You enclosed the Thank You in bold tags, and I cannot see what looks weird about it?

HTH

thanks, that did the job. i also added this after some search on the internet:

"<P STYLE='font-family:Times New Roman;font-size:15'>" & "<br><B>Hello,</B>" & "<br>" & "<br>" & "<i>PO Requisition #</i>" & " " & Range("I5") & "<br>" & "<i>Vendor: </i>" & Range("C5") & "<br>" & "<i>Total: </i>$" & Range("J43") & "<br>" & "<br>" & "Please Find the file(s) attached for more details." & "<br>" & "<br><B>Thank you.</B>"