HTML Format Question

[wmtsub]

Is it possible to specify a font and size and maybe color for only one line?

[LEFT][COLOR=#222222][FONT=Verdana]'sig
    ssig = vbLf _
    & vbLf _
    & vbLf _
    & sname _ ' would like to specify font and size and color here only
    & vbLf _
    & ttl _
    & vbLf _
    & " Division" _
    & vbLf _
    & "8120  Way" _
    & vbLf _
    & "Building [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=104]#104[/URL] " _
    & vbLf[/FONT][/COLOR]
[COLOR=#222222][FONT=Verdana] ssig = Replace(ssig, vbLf, Chr(60) & "br" & Chr(62))
' Apply left aligning
    sText = Replace(sText, "align=center x:publishsource=", "align=left x:publishsource=")
' Concatenate all parts for HtmlBody
    sText = sFont & sHtmlHeader & sText & ssig
' Insert sText into HtmlBody
    .htmlbody = sText & "<IMG src=""C:\Users\edwkov\AppData\Roaming\Microsoft\Signatures\EDS_files\small.png"">"[/FONT][/COLOR][/LEFT]

 

[sandy666]

are you sure this is an Excel question?

 

[wmtsub]

Yes , it is paert of a vba macro to export a signiture to an email.

 

[John_w]

Yes, it is possible, using the style attribute within HTML tags. See https://www.mrexcel.com/forum/excel...mail-excel-macro-post3939951.html#post3939951

 

[wmtsub]

Thanks, I will play with that .