Thread: Mail Merge
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
R. Choate
 
Posts: n/a
Default Mail Merge

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


"Kurch" wrote in message ups.com...
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