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.
![](/board/proxy.php?image=https%3A%2F%2Fi.ibb.co%2FfdcYVRy%2FEmail-Example.jpg&hash=29fc0bec04c9df0e1cf28248056013c6)
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.
![](/board/proxy.php?image=https%3A%2F%2Fi.ibb.co%2FfdcYVRy%2FEmail-Example.jpg&hash=29fc0bec04c9df0e1cf28248056013c6)
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