+ Reply to Thread
Results 1 to 5 of 5

Macro Button to send Entire Workbook as PDF via email

  1. #1
    Forum Contributor
    Join Date
    02-25-2010
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    138

    Macro Button to send Entire Workbook as PDF via email

    Good Afternoon,

    As per the subject, I am looking for a Macro + Button to send the entire workbook as PDF via e-mail.

    I have 3 sheets - "DAY SHIFT" "NIGHT SHIFT" "PRODUCT LIST" - (Product List Is Hidden)

    I want to send the day & night shift to PDF and leave the product list out of it.

    Can anybody please assist me?

    Regards
    Ross

  2. #2
    Forum Contributor
    Join Date
    02-25-2010
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    138

    Re: Macro Button to send Entire Workbook as PDF via email

    This is what I am currently using, But this only sends an .xlsx sheet.....


    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    01-18-2013
    Location
    Prague, Czech rep.
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    138

    Re: Macro Button to send Entire Workbook as PDF via email

    Hi Rosco88,

    here is the macro to save the sheets as PDF file:

    Please Login or Register  to view this content.
    just as stated enter proper filepath

    and regarding the sending part you have it right just instead of active workbook, give it a path to the file you wanna send with the double quotes

    best regards

    Soul

  4. #4
    Forum Contributor
    Join Date
    02-25-2010
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    138

    Re: Macro Button to send Entire Workbook as PDF via email

    Thanks Soul!

    I am also looking to add a CC to the below code.... Can anyone assist?

    Please Login or Register  to view this content.
    Thanks
    Ross

  5. #5
    Forum Contributor
    Join Date
    01-18-2013
    Location
    Prague, Czech rep.
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    138

    Re: Macro Button to send Entire Workbook as PDF via email

    You´re welcomed.

    and regarding your next request, I´m sorry, I´m not familiar with that piece. I use two options to mail things one is the simple one you´ve had up there and second to mail pictures and stuff in the body of the mail, but either of those is similiar to this...

    anyways I suggest you to close this thread as solved and create another one since its not relevant anymore I believe (if my previous proposal is working as desired).

    Also you might wanna consider the add reputation button if you liked my insights

    Best regards

    Soul

+ 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. command button VBA to send automated email not workbook or worksheet
    By lpratt in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-08-2012, 11:13 PM
  2. Macro to attach workbook to Outlook email but NOT send
    By kbwilsdon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2009, 06:57 AM
  3. Button - Send email
    By Wiets in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2008, 09:04 PM
  4. command button to send email
    By artromanov in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2007, 09:02 PM
  5. send email from button
    By andreww in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2005, 11:05 AM

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