Word merge does not readily lend itself to this sort of task, but for an
example of how it may be done, see :
How to use mail merge to create a list sorted by category in Word 2002 -
http://support.microsoft.com/?kbid=294686
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Kurch wrote:
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?