Excel sheet mail merge to email?

I have lots of sheets open in one book. Each sheet has a set of data using the same fields but with unique values – each sheet relates to an person. For the sake of argument lets say there are 26 sheets named “A,B,C... to Z”. What I want to do is email each sheet to the person to which it relates but I don’t want to have to do this manually 26 times – I want some kind of automated mail merge. So I want sheet ‘A’ to be emailed to ‘[email protected]’ and ‘B’ to ‘[email protected]’ etc. If it helps with a way of doing it the sheets can be set up to include the relevant email address on the page somewhere.

I do not mind what form the data is emailed as, it could be a word or pdf attachment or appear directly in the email, the important thing is to minimise the time it takes as I will have to send it out on a weekly basis and do not want to have to create each email separately.

Any help would be great. Thanks.

Thank you John. It works a treat and has saved me a lot of hours Thank you