Hi,

I wasn't sure if I should post this in here, or in the Excel area as it involves both programs.

I am sending out letters to groups of 10 people at a time, each of which is in an Excel spreadsheet with their name, address, company etc.

What I want to do is not only do a mail merge for each person, but also mention the 9 other people in each of the letters.

For example...

First letter is addressed to person A.
Within the letter it mentions the name of Person B, Person C, Person D etc...

The second letter is addressed to person B.
Within the letter it mentions the name of Person A, Person C, Person D etc...

Is there a way for me to automate this process?

Richard