+ Reply to Thread
Results 1 to 2 of 2

Excel VBA code for saving PDF to file & adding default signature to Email

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    648

    Excel VBA code for saving PDF to file & adding default signature to Email

    I have working code that takes a worksheet and automatically places it in outlook. I would like to add that the code looks to see if outlook is open and if not... open it first, and also when it places the range into the body of email it would also ncluded the default signature in outlook & if the code could also save a PDF of the file that is sent in a designated folder as PDF for reference at a later date.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Excel VBA code for saving PDF to file & adding default signature to Email

    Hi, bdouglas1011,

    Insert Outlook Signature in mail and Create and Mail PDF files with Excel 2007/2013 should help.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for 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. 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
  2. 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
  3. 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
  4. vb code for default user signature
    By cooket4 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2012, 10:04 AM
  5. 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