+ Reply to Thread
Results 1 to 2 of 2

Adding user default signature to Outlook Macro

  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    12

    Adding user default signature to Outlook Macro

    Morning!

    I have the macro below in a workbook with a number of purchase orders, to automatically turn the current sheet in to a .pdf and then email it to the supplier. It works great but there's two things I wanted to add, and I'm hoping someone here can help out.

    1. Have the default out signature of the current user be in the email.
    2. Save the .pdf file in the same folder as the current workbook, but in to a specific sub folder. The name of the current folder will vary constantly, but the name of the sub folder will always be 'Purchase Orders'

    Hopefully this is enough information, if not, let me know.

    Thanks in advance!
    Please Login or Register  to view this content.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Adding user default signature to Outlook Macro

    See https://www.rondebruin.nl/win/s1/outlook/signature.htm
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Adding Default Signature to Macro Generated Email
    By michaelobecker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2018, 02:56 PM
  2. [SOLVED] VBA adding default outlook signature to an outlook html message
    By jlive24 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2018, 11:59 AM
  3. [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
  4. html body and default Outlook signature??
    By michud08 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2017, 11:11 AM
  5. [SOLVED] Get Default Signature of outlook
    By naveenmarapaka in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2014, 08:17 AM
  6. Email macro, include variable in body & add default outlook signature
    By promithius in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2013, 09:05 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

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