Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query a mail merge for multiple letters at once? | Mailmerge | |||
skipped mail merge records | Mailmerge | |||
Mail merge option with multiple data source records in one letter. | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
How to Mail merge records into a new/separate document | Mailmerge |