Mail Merge multiple records on One Contract/Letter

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

Hi HurlyGurly,

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?

You'll find a discussion on this in the "Special Merges" area of my website's
Mail Merge FAQ. There are links to documents that discuss the three different
approaches that are available.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)