Archive of Mr Excel Message Board

I handle all the manuals for a large insuranbce company. My problem is I have a report that shows me manual information on terminater employees. the report has two column (employee name and contact name). I need to be able to merge the contact data with the employee data in a mail merge in Microsoft word. Here is the problem sometimes the terminated employee will have more than one manual, the spreadsheet shows the same contact for the employee however many times a manual is assigned. I want to only place the contact in a Microsoft Word field one time with the number of manuals assigned to that contact.

I kno this is not an easy one.

If anyone knows or has any ideas, please let me know.

Thanks

Jack