I have a mail merge directory with an employee as the main data and a list of their contacts as the listed (directory) data. Everything works fine except that the dept. head would like to see 2 separate lists of data per employee.

Basically, all of the employee information (name, address, etc.) is at the top of the letter. A list of their contacts follows soon after. There's then some paragraphs in the middle of the document, and I need to then display the contacts' address information in a directory style at the end of the letter.

The letter might look like this:

Employee Name
Employee Address

Contact 1
Contact 2
Contact 3
Contact 4

Two paragraphs of the letter.

Contact 1 Address


Contact 2 Address
Contact 3 Address
Contact 4 Address

From what I've seen, Word can't do this. It just wants to stack the directory data all in one place and not have some other paragraphs separating the directory data. Am I wrong? If the contact data was all together, there wouldn't be a problem. It needs to be separated, though.

Any help would be great. Thanks!

As per my reply to your other thread, this really isn't something Word's mailmerge tools support. It might be possible to add that functionality to my Microsoft Word Catalogue/Directory Mailmerge Tutorial, but it's the kind of thing that might be better developed in vba.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for getting back to me. I couldn't find a resolution, so we ended up restructuring the letter so that all of the directory data was grouped together.