--------------------------------------------------------------------------------

Hi all, I wonder if anyone can help me.

Basically, I have a spreadsheet which contains a list of authors and their respective publications. Each row within the spreadshee represents a publication, recording information such as title, date etc. There are also two cells within each row which record the author name and a unique identifyer for that author. So, each person/reference may only occur in the spreadsheet once, or similarly a number of times, depending on how many publications they have had.

I want to send out a version of this spreadsheet to each author, say, every 3 months, asking them to add in any new publications they have had since the last update. The version of the spreadsheet each author should see should only show the publications that belong to them - that way they can see what information I already have and can i) update the information as necessary and ii) add in new publications. I will then add this data back into the main master copy from each author to update my records.

Obviously, I could create and send out a filtered spreadsheet manually for each person, but given the large number of people it would be good if I set Excel to automatically generate and email the bespoke version of the spreadsheet for each person (mail merge, perhaps?). Is this possible?!

Thanks in advance