Hi there,
I have a sheet named "Emails" set up with various emails addresses, subjects etc.
I want to email a copy of the spreadsheet renamed to another name sent to the list of email addresses I have listed in cells.
Staff that use the spreadsheet have no idea how to edit a VBA script and as personnel are always changing I just want to change the new details in the cells rather than edit a VBA script each time.
Here is an example picture of my list and I want to be able to change everything that is in red.
It would also need to be able cope with blank cells like C7.
After the email is sent I still wish to have the spreadsheet keep it's original name.
Any help would be greatly appreciated.
Phil
I have a sheet named "Emails" set up with various emails addresses, subjects etc.
I want to email a copy of the spreadsheet renamed to another name sent to the list of email addresses I have listed in cells.
Staff that use the spreadsheet have no idea how to edit a VBA script and as personnel are always changing I just want to change the new details in the cells rather than edit a VBA script each time.
Here is an example picture of my list and I want to be able to change everything that is in red.
It would also need to be able cope with blank cells like C7.
After the email is sent I still wish to have the spreadsheet keep it's original name.
Any help would be greatly appreciated.
Phil
