Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
315 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.