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

Leave a Reply

Your email address will not be published. Required fields are marked *