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

Hi Richard,

In this case, you can employ a database field, where you:
• use your Excel worksheet as the data source for the merge; and
• insert a DATABASE field into the mailmerge main document to select the records for each individual’s letter.
For example, if your workbook is called ‘c:\mywbs\teams.xlsx’ and the sheet is called Sheet1, the following nested field codes, which includes the database query, should result in a one-column table with the name of each participant in the group, other than the individual to whom the letter is addressed:
{DATABASE \d "C:\\a\\mywbs\\teams.xlsx" \s "SELECT [firstname] & ' ' & [surname] FROM [Sheet1$] WHERE [ID] <> {MERGEFIELD ID}"}
You can apply the DATABASE field formatting switches to get a suitable table format.

Note 1: the above assumes your records have both a 'firstname' field and a 'surname' field.

Note 2: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]