VBA Code for Emailing to Multiple Recipients Listed in Cells

[ExcelPhil]

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

 

[ExcelPhil]

I forgot to mention that I use Outlook to email.

 

[ExcelPhil]

Anyone?