Send email from Excel

Question

I'm opening an outlook email from excel using vba. I would like to format the body, eg. using a certain font and making a few words bold. Is this possible?

Here is my vba for opening an email:

Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(olMailItem)
With OutMail
    .To = strRecipient
    .CC = ""
    .BCC = ""
    .subject = strSubject
    .body = strBody
    .Display
End With

Answer 1

You'll need to use the HTML mail format for that:

OutMail.BodyFormat = olFormatHTML
OutMail.HTMLBody = "<b>Bold</b>, not bold"