• WSswampcritter

    WSswampcritter

    @wsswampcritter

    Viewing 1 replies (of 1 total)
    Author
    Replies
    • in reply to: Add Signature to HTML email using VBA #1512993

      Bob,

      I can’t tell you how many solutions I have tried to do what you are asking but never found anything that really worked. As a workaround you can do what I do.

      1. Create an Outlook signature without a logo. Your default signature is the first one in the “C:UsersMaudibeAppDataRoamingMicrosoftSignat ures” folder so make this created signature appear first by naming it something that will be first in alphabetical order. Using the .HTMLBody property, compose your message with the Signature variable at the end of your HTML code (see code post#2) then apply an image tag after a break tag. If your image is sized right, it will appear as part of the signature.

      Code:
      .HTMLBody = “Hello,” & “
      ” & Range(“H12”).Value & “
      ” & “
      ” & “
      ” & _ “Thank you,” & “
      ” & “
      ” & Signature & “
      ” & _ “

      2. Instead of using the default signature, build your signature right in the .HTMLBody property value then apply the image tag as above.

      HTH,
      Maud

      In the .htm file in the signatures directory you can edit the htm file. The pictures are stored as relative path and when you use the code it looses that path so if you use discrete path it will be able to find the pictures. so go into the file and look for any relative paths and make them discrete.

      “/Microsoft/Signatures/picturefile.jpg”

      change that to include the whole path

      “/root/user/blah blah../Microsoft/Signatures/picturefile.jpg”

      This solved the missing image problem for me.

    Viewing 1 replies (of 1 total)