I have the below code to send an email. I'd leave it working as is except I want to make some of the cell references bold. Have read many other threads about changing the .body to .htmlbody and changing the carriage returns to <br>. Unfortunately, I can't get anything to work, apart from the below which isn't HTML. Any assistance would be very much appreciated - don't be shy to let me know of any fundamental problems with my VBA attempt!
VBA Code:
Sub Email()
Dim OutApp As Object
Dim OutMail As Object
With Application
.EnableEvents = False
.ScreenUpdating = False
End With
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
With OutMail
.To = Range("f300")
.CC = Range("f302")
.BCC = Range("f304")
.Subject = Range("f306")
.Body = Range("f310") & vbLf & _
"" & vbLf & _
Range("f312") & vbLf & _
"" & vbLf & _
"" & vbLf & _
Range("f314") & vbLf & _
"" & vbLf & _
"" & vbLf & _
Range("f316") & vbLf & _
"" & vbLf & _
Range("f318") & vbLf & _
"" & vbLf & _
Range("f320") & vbLf & _
"" & vbLf & _
Range("f322") & vbLf & _
"" & vbLf & _
Range("f324") & vbLf & _
"" & vbLf & _
.Display
End With
On Error GoTo 0
With Application
.EnableEvents = True
.ScreenUpdating = True
End With
Set OutMail = Nothing
Set OutApp = Nothing
End Sub