Mail Merge with Info on different lines. richge 10/7/2008 4:03:02 PM 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.

Re: Mail Merge with Info on different lines. "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 10/7/2008 7:29:58 PM 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" <richge[ at ]discussions.microsoft.com> wrote in message news:9D0B8A3F-C2F3-4A44-BE08-9D58CF9D624E[ at ]microsoft.com... [Quoted Text] > 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.

Re: Mail Merge with Info on different lines. "macropod" <macropod[ at ]invalid.invalid> 10/9/2008 7:15:42 AM To see how to do this kind of mailmerge, check out my tutorial at: http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107 -- Cheers macropod [MVP - Microsoft Word] "richge" <richge[ at ]discussions.microsoft.com> wrote in message news:9D0B8A3F-C2F3-4A44-BE08-9D58CF9D624E[ at ]microsoft.com... [Quoted Text] > 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.