+ 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

    Youre welcomed.

    and regarding your next request, Im sorry, Im not familiar with that piece. I use two options to mail things one is the simple one youve 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