I need to create a pdf that will be attached to an email with the click of a button.
Essentially I have a report that I must send out every day at the same time. I would like this button to print a pdf of my "Report" sheet and attach it to an email within Outlook.
I believe this is where it may get tricky:
1) I would like the pdf to be saved as "AB Power Marks, Today()"
2) I would like the subject of the email to match the name of the pdf: ""AB Power Marks, Today()"
3) I would like the body to read as:
"Hello,
These are the AB power marks as 12:30 MST for Today()
If you have any questions or concerns regarding any of the information provided on the sheet please contact me. All of my contact details can be found below.
Have a good day!
Regards,"
Attached is a copy of my spreadsheet. I would appreciate any help.
I have scoped out the forums and you seem to be very knowledgeable in this subject.
Thank you!
Test.xlsx
Bookmarks