
4,397 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
.Body = "Dear Sirs" & vbCr & vbCr & "Please find attached the Umpires Report Form for the match indicated." & vbCr & vbCr & "Should you require any further information then please don't hesitate to get in touch." & vbCr & vbCr & "Kind regards," & vbCr & Range("a37") & vbCr & "For and on behalf of" & vbCr & Range("b37")
Try something like this:
.BodyFormat = olFormatHTML
.Body = "Dear Sirs<br/><br/>Please find attached the ...<br/><br/>" & "For and on behalf of <br/><br/> <b>" & Range("b37") & "</b>"
If this concept works, the values of the ranges must be escaped according to HTML rules to avoid incorrect formatting.