+ Reply to Thread
Results 1 to 12 of 12

Default signature at the end of email

  1. #1
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Default signature at the end of email

    Hi I am using this code to automatically draft a email from excel but unable to get default signature.

    Please help me to get default signature at the end of email.

    Please Login or Register  to view this content.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Default signature at the end of email

    You can set your signature IN Outlook, you dont need VBA for that
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Re: Default signature at the end of email

    Hi Ford,

    Thank you for your reply!

    I have alrady set My signature in Outlook but when i run macro defalt signature did not polulate at the end of email.

    Regards,

    Xlhelp

  4. #4
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Re: Default signature at the end of email

    Any update!

    Regards,

    Xlhelp7

  5. #5
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Default signature at the end of email

    You can set your default signature in your gmail account.
    in setting you will get the option.
    hth
    Sincerely,

    mso3

  6. #6
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Default signature at the end of email

    Hi Try this below code

    Please Login or Register  to view this content.
    Last edited by Naveed Raza; 07-19-2016 at 07:30 AM.
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Default signature at the end of email

    Quote Originally Posted by mso3 View Post
    You can set your default signature in your gmail account.
    in setting you will get the option.
    hth
    As far as I can tell, OP is using Outlook, not Gmail?

  8. #8
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Re: Default signature at the end of email

    Hi Naveed

    Thanks for the reply!

    when i run you code it says variable not defined

    Regards,

    Xlhelp7

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Default signature at the end of email

    Try recording a macro to just send some dummy email and see if the sig gets left off when you run the test macro?

  10. #10
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Default signature at the end of email

    Quote Originally Posted by xlhelp7 View Post
    Hi Naveed

    Thanks for the reply!

    when i run you code it says variable not defined

    Regards,

    Xlhelp7
    hi,

    try this code

    Please Login or Register  to view this content.

  11. #11
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Re: Default signature at the end of email

    Naveed, that is exactly what I am looking for. Works a treat. Thank you!

    Regards,

    Xlhelp7

  12. #12
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Default signature at the end of email

    Hi xlhelp7,

    Glad to help you

    if you happy with the solution then could you please close the thread and click on * Add Reputation to say thank.

+ 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. Use VBA to send email from Outlook and use senders default signature
    By BillDoor in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-21-2015, 11:02 AM
  3. Trying to add a default signature into an email from VBA
    By murp5972 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-13-2015, 09:33 AM
  4. [SOLVED] default email signature
    By bigfishprf in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-08-2015, 10:55 AM
  5. generating automatic email with default signature and hyperlink
    By jerrydiaz in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2014, 11:55 AM
  6. send selected range in email with default outlook email signature included
    By mdsickler in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2013, 10:50 PM
  7. Unable to link default email signature to email
    By paxile2k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2010, 06:52 PM

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