[richge]

I'm doing a mail merge with an Excel Database. Information about the
employee, his spouse and dependents is on separate lines. All members are
listed under the employees social security #. In the merge I need the
employees name on the first line, the spouse's name on the next line and
dependants' names on separate lines under that. How can I get the merge to
pick up the info on the next lines under the employee's social security #,
but go to the next social # after it has picked up all dependants?

Thanks.

[Doug Robbins - Word MVP]

See
http://cornell.veplan.net/article.aspx?&a=3815


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"richge" wrote in message
...
I'm doing a mail merge with an Excel Database. Information about the
employee, his spouse and dependents is on separate lines. All members are
listed under the employees social security #. In the merge I need the
employees name on the first line, the spouse's name on the next line and
dependants' names on separate lines under that. How can I get the merge
to
pick up the info on the next lines under the employee's social security #,
but go to the next social # after it has picked up all dependants?

Thanks.

[macropod[_2_]]

To see how to do this kind of mailmerge, check out my tutorial at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=731107

--
Cheers
macropod
[MVP - Microsoft Word]


"richge" wrote in message ...
I'm doing a mail merge with an Excel Database. Information about the
employee, his spouse and dependents is on separate lines. All members are
listed under the employees social security #. In the merge I need the
employees name on the first line, the spouse's name on the next line and
dependants' names on separate lines under that. How can I get the merge to
pick up the info on the next lines under the employee's social security #,
but go to the next social # after it has picked up all dependants?

Thanks.