Most valuable professional
  • Hot Topics

Excel Formatting an email in VBA?

I have the following code which creates an email after selecting cells in Excel. The Email defaults to Font Calibri 12. If I want to make B17 bold and B28 in Calibiri 8, how do I incorporate within the code? Many thanks, ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Sub Create_Individual_Email() 'Sending email to individual partners Dim OutApp As Object Dim OutMail As Object Dim strbody As String Sheets("Message").Visible = True Sheets("Message").Select Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .To = "" & Range("B2").Value & "" .Subject = "" & Range("b4").Value & vbNewLine .Body = "" & Range("b6").Value & vbNewLine & _ "" & vbNewLine & _ "" & Range("b8").Value & vbNewLine & _ "" & Range("b10").Value & vbNewLine & _

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of July 11, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel