Macro to send PDF from excel


I would like help being a macro basic user to do the following:


– create a PDF of the current excel sheet (sheet 1, not the whole workbook)

– attach the PDF file to an outlook email without having to save the PDF

– have a set email subject “Monthly Report attached”

– have a set email body “Hello Team, please see attached this months report”

– send the email to a set number of email addresses

– send the email automatically once a week


Hope that makes sense!!  Trust someone can help.  



By: Chad

2 thoughts on “Macro to send PDF from excel

  1. ig

    I will immediately snatch your rss feed as I can not find your e-mail subscription hyperlink or e-newsletter service.
    Do you’ve any? Please permit me recognise so that I may subscribe.

  2. Erik Bigney

    Hi there very nice website!! Guy .. Excellent .. Amazing .. I will bookmark your blog and take the feeds additionally…I’m happy to seek out numerous helpful information here within the post, we’d like develop extra strategies in this regard, thank you for sharing. . . . . .

Comments are closed.