+ Reply to Thread
Results 1 to 4 of 4

VBA adding default outlook signature to an outlook html message

  1. #1
    Registered User
    Join Date
    06-26-2018
    Location
    us
    MS-Off Ver
    10
    Posts
    12

    VBA adding default outlook signature to an outlook html message

    Hi Everyone,

    I've created a macro that sends ranges to an outlook body, but I am having trouble having the email display my default outlook signature. This macro will be used by everyone on my team, so it needs to be able to display the signature of whoever is using it.

    Below is the code I am currently working with. Any help would be appreciated!
    Please Login or Register  to view this content.

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,006

    Re: VBA adding default outlook signature to an outlook html message

    Hi,

    For the default signature to exist in the first place, you need to .Display first.... there are more complex ways but that is the easiest. Below is a small modification to your code that will hopefully work. I have moved the .Display, and the "signature=..." lines:

    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    06-26-2018
    Location
    us
    MS-Off Ver
    10
    Posts
    12

    Re: VBA adding default outlook signature to an outlook html message

    Quote Originally Posted by Arkadi View Post
    Hi,

    For the default signature to exist in the first place, you need to .Display first.... there are more complex ways but that is the easiest. Below is a small modification to your code that will hopefully work. I have moved the .Display, and the "signature=..." lines:

    Please Login or Register  to view this content.
    Thank you! This worked perfectly!

  4. #4
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,006

    Re: VBA adding default outlook signature to an outlook html message

    Excellent! Glad I could help out jlive24

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] outlook VBA: how to add alternative signature to email instead of the default
    By Marijke in forum Outlook Formatting & Functions
    Replies: 13
    Last Post: 11-03-2017, 08:36 AM
  2. html body and default Outlook signature??
    By michud08 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2017, 11:11 AM
  3. [SOLVED] Add Default Signature When Sending a Range as HTML in Outlook e-Mail
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2014, 12:40 PM
  4. [SOLVED] Get Default Signature of outlook
    By naveenmarapaka in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2014, 08:17 AM
  5. HTML to Range -> OutApp: Outlook | Signature Issue
    By clprdctn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2014, 12:14 PM
  6. Excel ws into outlook html body with current html signature
    By Cadelanne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2014, 09:03 AM
  7. Getting Outlook To Add Default Signature
    By McNulty in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-13-2009, 01:17 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1