Thankyou for you help.
Each sheet however has different data sets which would cause confusion if
the individuals received it on the one page.
I've tried to merge the macro I currently use with the one to merge the
indiviudals data onto their separate workbooks and then the macro for
emailing the entire workbook, but was unsuccessful.
I understand if this macro is not possible.
Thankyou once again for the advise you've given.

"Ron de Bruin" wrote:

Hi Tamara

Merge the data from the sheets you want in one master sheet and run the mail macro
on that master sheet.

See
http://www.rondebruin.nl/copy2.htm

Read the tips below the first macro

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tamara" wrote in message ...
Hi, I've been sucessfully using the "Mail a row or rows to each person in a
range (as attachement)" from Rondebruins site (Fantastic site !!!) which
emails each individual with only their data found on the spreadsheet. My
workbook has expanded resulting in the individuals receiving multiple emails
as the macro can only email one sheet at a time. Is it possible to modify
the macro to read multiple (not all) pages within the workbook, find the
matches and email these sheets in the one workbook? Any help would be much
appreciated!!