K
Kurch
I have a long list of names and job titles in Excel. I want to merge
the data into a Word
document, that will become a salary agreement. I need to combine each
person's job onto one letter.
Many of the names are listed several times because they have several
jobs. Each name is on 1 row.
Here is an example:
Name Job
John Doe Teacher
John Doe Coach
Mary Smith Teacher
Mary Smith Club Advisor
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?
the data into a Word
document, that will become a salary agreement. I need to combine each
person's job onto one letter.
Many of the names are listed several times because they have several
jobs. Each name is on 1 row.
Here is an example:
Name Job
John Doe Teacher
John Doe Coach
Mary Smith Teacher
Mary Smith Club Advisor
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?