You are trying to perform a "multiple items per condition (=key field)"
mailmerge which Word does not really have the ability to do:
See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at
http://homepage.swissonline.ch/cindy...faq1.htm#DBPic
Or take a look at the following Knowledge Base Article
http://support.microsoft.com/default...b;en-us;211303
or at
http://www.knowhow.com/Guides/Compou...poundMerge.htm
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Kurch" wrote in message
ups.com...
I am trying to perform a mail merge that will result in several
thousand salary agreements. Each salary agreement will have a person's
name, job and salary. The problem is that most people have several jobs
hence they occupy several rows in the list. When I perform the mail
merge people with more than one job appear os a separate letter. I am
having difficulty figuring out how to combine each person's job onto
one letter.
This is what my list looks like
Name...............Job..................Salary
John Doe..........Teacher..........39,000
John Doe..........Coach...............2,000
Mary Smith.......Teacher............40,000
Mary Smith........Club Advisor......1,000
When I perform a typical mail merge separate letters are generated for
each job because the mail merge sees each row as a separate record. I
need to find a strategy to create one letter for each name with each
job listed.
Is there a mail-merge trick I can use to combine the jobs into a single
letter?