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