Advanced Mail Merge-Combining Records

Hi,

I'm familiar with mail merge in creating standard form letters and mailing labels.

This is the deal, I have a list of guests, varying from 2-4 ppl per account. Here's a two column example:
Account#-Name
97 - Jim Doe
97 - Phyllis Doe
5680 - Diane Black
5680 - Doug Black
5680 - Steve Black
5680 - Maureen Black
123 - Jim Spade

I would like to create single letters for each group Account# that will include all the names of each guest for that account in word. I found this article about combining records http://cornell.veplan.net/article.aspx?&a=3815 but was unable to get it to work.

Any help would be appreciated. BTW I'm using old, 2000 versions of excel and word. I could also do this in open office if that helps.

Hi

I have the same problem and was unable to resolve that. So to solve this poblem , I used export facility to transfer the data from Access to Excel and then I had written VBA code to combine records in the same row whose account no is same..
E.g
Account Customer1 Customer2
97 Jim Doe Phyllis Doe

etc...

Then I used that sheet in the mailmerge to send single letter for each group Account#.

I know this is just the alternative to solve that problem. If you get the exact answer of this question without exporting into excel then please let me know.

Regards
Raj
[email protected]

attached is a way of doing it
last column gives names in format john and jane doe or john ,jane and sue doe depending on how many names you have per family

Hello jkanclerz,

If would be easier to answer your question if you provide more detail about what problems you are experiencing. The link you provided tells you how to modify Word to combine like fields and put them on separate pages. Is your problem with adding this code to Word or getting Word to access the Excel data?

Sincerely,
Leith Ross