Word merge from Access, multiple matches

[Joseph Hill]

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:

+------------+------------+------------+
| id | schoolname | group |
+------------+------------+------------+
| 1 | one | 1a |
+------------+------------+------------+
| 2 | two | 2a |
+------------+------------+------------+
| 3 | three | 1b |
+------------+------------+------------+
| 4 | four | 1a |
+------------+------------+------------+
| 5 | five | 2a |
+------------+------------+------------+
| 6 | six | 2a |
+------------+------------+------------+
| 7 | seven | 1a |
+------------+------------+------------+
| 8 | eight | 1a |
+------------+------------+------------+
| 9 | nine | 1b |
+------------+------------+------------+

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!

 

[Doug Robbins]

Not something that Word does very well (or at all). Really easier to do
with a report in Access.

But you might also take a look at the "Multiple items per condition" item
under the "Special merges" section of fellow MVP CIndy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Joseph Hill]

Not something that Word does very well (or at all). Really easier to do
with a report in Access.

But you might also take a look at the "Multiple items per condition" item
under the "Special merges" section of fellow MVP CIndy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Hi

Thanks a lot - linked off that site was
http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm - which
seems to be just the ticket.

Appreciated,

Joe