I have an Excel spreadsheet that auto saves and sends an email when closing the spreadsheet.
I have two problems at the moment.
1) I would like the subject line in an auto send email to reference three different cells. (F1, E2 and D3 are the locations)
2) I would like the ability to remove 2 users from sending the auto email (Outlook). There's 4 of us total that will access the spreadsheet, but only 2 of us need to send the auto email, the other 2 will review and audit there work, thus an auto email is not necessary.
Any help would be greatly appreciated.
Thanks
Bookmarks