How to set email signature style RRS feed

  • Question

  • Hi,

    I want to send a email with signature. but I don't know how to set it style. I want my signature isn't black font and I want set font size.

    Do you have a good method? I need your help.


    Tuesday, October 30, 2018 1:43 PM


  • Hi yi123456789,

    You could refer to the below code:

    SigString = "<H3><B style=’color: blue;’>Dear Customer Ron de Bruin</B></H3>" & _
                  "Please visit this website to download the new version.<br>" & _
                  "Let me know if you have problems.<br>" & _
                  "<A HREF=’’>Ron's Excel Page</A>" & _
                  "<br><br><B>Thank you</B>"

        If Dir(SigString) <> "" Then
            Signature = GetBoiler(SigString)
            Signature = ""
        End If
        On Error Resume Next

        With OutMail
            .To = ""
            .CC = ""
            .BCC = ""
            .Subject = "This is the Subject line"
            .HTMLBody = strbody & "<br>" & Signature
            .Send    'or use .Display
        End With

    For more information, Please refer to this link:



    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread.

    • Marked as answer by yi123456789 Wednesday, October 31, 2018 12:16 PM
    Wednesday, October 31, 2018 6:15 AM