Mail Merge

[Kurch]

Hello,

I have a large list of names and job titles I want to merge into a Word
document, that will become a salary agreement. I hope to combine each
person's job onto one letter.

The problem is that when a person has more than one job they are listed
on more than one 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. I wante them combined into one letter.

Is there a mail-merge trick I can use to combine the jobs into a single
letter?

Thanks

 

[Debra Dalgleish]

Word MVP Cindy Meister has merging instructions that may help you:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

 

[R. Choate]

Or perhaps just using a list of unique names for your letter will do what you need if the letter would still do what you want. that
would be easy enough.

HTH
--
RMC,CPA


Hello,

I have a large list of names and job titles I want to merge into a Word
document, that will become a salary agreement. I hope to combine each
person's job onto one letter.

The problem is that when a person has more than one job they are listed
on more than one 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. I wante them combined into one letter.

Is there a mail-merge trick I can use to combine the jobs into a single
letter?

Thanks