Macro to send PDF from excel

Hello

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.  

Regards

Chad

By: Chad

Leave a Reply

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