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?