Font Style For E-mail Body In Vba

I have the following code written in VBA: Dim StrBody As String StrBody = 'Text Line 1' & '' & _ 'Text Line 2' & _ How do I change the font to

Solution 1:

I imagine you would have to use the font tag and its various attributes:

StrBody = "<font size=""10"" face=""Arial"" color=""red"">" & _
          "Text Line 1" & "<br>" & _
          "Text Line 2" & _ 
          "</font>"

Make sure the " quotes used to surround HTML attribute values don't get interpreted as the end of the VBA string: escape them by writing "" instead, as in the example above.

color can also be specified as hexadecimal RGB codes. So color="red" could be replaced by the more general color="#FF0000".