Results 1 to 3 of 3

vba to print active sheet to pdf, auto save in specific folder then mail using outlook

Threaded View

  1. #1
    Registered User
    Join Date
    07-17-2014
    Location
    birmingham
    MS-Off Ver
    2003
    Posts
    3

    vba to print active sheet to pdf, auto save in specific folder then mail using outlook

    Hello there

    How do I write a vba code to print active sheet to pdf, auto save in specific folder then mail using outlook

    im using 'Nitro PDF Creator'

    also id like it to automatically save the pdf as the same file name as the active worksheet and also auto enter the following when opening the email server:-

    Address: Cell D18
    Subject: Cell D21
    Email body:

    Paul

    Please find attached quotation

    • Optional installation available on request

    thank you please help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to print and save a document to specific folder with unique number
    By kasenga in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2014, 09:59 AM
  2. How to copy Sheet to a new workbook and save to a specific folder
    By moxman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2014, 07:43 PM
  3. Trying to save a Mail Merge word Document to a specific folder
    By jtemp57 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2014, 06:56 PM
  4. auto save e-mail attachment to folder after sending
    By ncaravela in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2010, 05:23 PM
  5. [SOLVED] I like to open a folder,auto print,save then close
    By tied of opening files in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2005, 06: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