I've got staff timesheets that I want to export to pdf each week and then email automatically to them using Outlook
I have the filename in cell B1 on each sheet and the email address in cell E1 on each sheet
I want the pdf saved in the same folder as the spreadsheet.
I've been banging my head against the wall for a few hours trying to figure this out, but thought it was time to consult the experts.
Any help would be sincerely appreciated!
I have the filename in cell B1 on each sheet and the email address in cell E1 on each sheet
I want the pdf saved in the same folder as the spreadsheet.
I've been banging my head against the wall for a few hours trying to figure this out, but thought it was time to consult the experts.
Any help would be sincerely appreciated!