+ Reply to Thread
Results 1 to 3 of 3

Add Default Signature When Sending a Range as HTML in Outlook e-Mail

  1. #1
    Forum Contributor
    Join Date
    02-04-2014
    Location
    Florida, United States
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    366

    Add Default Signature When Sending a Range as HTML in Outlook e-Mail

    Hello Everyone,

    The below CODE is my (adapted from the works of Ron De Bruin) Sub that sends a Range to an HTML e-Mail for distribution to Customers. How do I ammend the below code to also include the default signature in Outlook? As it stands, signatures have to be manually added to each distributed e-Mail.

    Any help would be really appreciated, and thank you.


    Please Login or Register  to view this content.

  2. #2
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: Add Default Signature When Sending a Range as HTML in Outlook e-Mail

    Hi,

    Check the below link from Ron De Bruin for adding signatures to mail. Hope this will help you:

    http://www.rondebruin.nl/win/s1/outlook/signature.htm


    Regards,
    Paresh J
    Click on "* Add Reputation" as a way to say thanks

  3. #3
    Forum Contributor
    Join Date
    02-04-2014
    Location
    Florida, United States
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    366

    Re: Add Default Signature When Sending a Range as HTML in Outlook e-Mail

    Yes, I found that and it did not work until I read it again and realized I had forgotten the .Display line had to be moved.

    Thank You!

+ 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. 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
  2. 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
  3. Replies: 7
    Last Post: 08-11-2012, 02:39 PM
  4. Sending email with outlook signature
    By sexcel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-04-2008, 10:12 PM
  5. Replies: 1
    Last Post: 03-04-2005, 02:06 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