How can I get the Range ("b37") to print as bold in an e-mail when I run the macro@

Question

         .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")

Answer 1

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.