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.