macro to send different sheets to different recipients as per list

Hi Experts

in sheet 1 there is a list of recipients and the name of the sheets. Other sheet contain data to be send to recipients.

My requirement is a macro that will send each sheets to the recipients as per the list in Sheet 1
Attached a workbook for ref.

Replace all you code with the following...tested and works. I think the problem was that you were not indicating a path for the file you were saving therefore the code was trying to attach a non-existent file. I have also changed your access to Outlook from early binding, which requires the MS Outlook Library to be installed to late binding which does not and is more inter operable across different versions.

Please Login or Register  to view this content.

The above code is not attaching the file, not even separating sheets and creating new file, it only creates a new mail with the recipient name

The following code is working fine for me. The only problem with the code is that, I have to place recipient in each sheet.
Also with this code i donot have to install any outlook libery and easy to use
It picks up the recipient name from A1 of each sheet and send the sheet to the recipient, but because there are many sheets and different recipients each time, it is also time consuming.
I need the code to pick the recipient name from the list given in the first sheet, remane the file as sheet name and then send to the recipient.

Also if possible it marks as send in the list in the first sheet

HTML Code: 

I did test my code it it worked as expected (create copy of sheet, create email, attach doc file attach spreadsheet and send) delete file...perhaps the difference is in version I am on 2013.

Yes, might be b'coz I might using 2007. Any way thank you, any other solutions that can be run in any version.

Any help please