I am trying to do a mail merge with data from an Access Database.

I have a main word doc, which is a "Contract form Letter" with all the
appropriate fields from a query.

The query is designed to give me all artists and the venues that they are
performing at.



The problem is that each Artist is performing at multiple venues.

So how do I get the mail merge to print ONE letter per artist, showing all
Venues for that Artist?



I.E. My query gives me data as follows;



ARTIST VENUE

John Smith Toronto

John Smith Ottawa

John Smith Montreal

Jane Doe New York

Jane Doe Boston



I only need ONE letter for John showing all 3 venues.

Then the next letter for Jane showing the 2 venues.



Can this be done.



Thanks in advance