I am familiar with how to mailmerge in Word from an Access table or
query.

Merging from an Access query is quite easy when there is only one
return to manage.

For example - my query will return the following data:

+------------+------------+------------+

+------------+------------+------------+

+------------+------------+------------+

+------------+------------+------------+

+------------+------------+------------+

+------------+------------+------------+

+------------+------------+------------+

+------------+------------+------------+

+------------+------------+------------+

+------------+------------+------------+

+------------+------------+------------+

If I want to find which `group` school with `id` of '7' belongs to,
that's easy - I know it's '1a' - and I can quite easily merge that
into the Word mailmerge.

However,

If I wanted to include a list of all people also in `group` '1a' how
would I go about that? I'd like not to set up a new mailmerge for each
`group` - and would like to just merge the rest of the data (there's a
lot more than shown above!) and list for each school the names of the
schools in the same group.

Can this be done? If so - can someone show me how? thanks!