Setting html Text Font in Email Body in VBA

[justinMEEE]

I have a VBA script in an excel file that will generate an email.
My problem is setting the font in the email.

This code works:

strbody = "****** style=font-size:11pt;font-family:Arial>Hello.</BODY>"

This code does not work:

strbody = "****** style=font-size:11pt;font-family:Segoe UI Symbol>Hello.</BODY>"

The only different is the font-family now has spaces in its name.

How do I choose fonts with spaces in their names?

 

[Worf]

Like this:

' Outlook module
Sub CreateHTMLMail()
Dim olApp As Outlook.Application, objMail As MailItem, strbody$
Set olApp = Outlook.Application
Set objMail = olApp.CreateItem(olMailItem)
strbody = "[SIZE=3]" & _
"Text Line 1" & "
" & "Text Line 2" & "[/SIZE]"
With objMail
    .BodyFormat = olFormatHTML
    .HTMLBody = "******>My text" & strbody
    .Display
End With
End Sub

edit: The forum software interpreted the tags…

 

[John_w]

Put single quotes (apostrophes) around the style attribute:

style='font-size:11pt;font-family:Segoe UI Symbol'

 

[Worf]

This is what I was trying to post: