See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at

http://homepage.swissonline.ch/cindy...r/MergFram.htm


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"Plucky" wrote in message
...
I have no trouble creating a "flat file",

my problem is, i want to create a mail merge that will merge to 300
people,
and each person has a list of items from the database that need to be
displayed.

so if i outerjoin the person's record to their list of 15 items, i would
have that person's name in 15 records.

Seems like mail merges are only meant to use 1 data source...so i'm
thinking
i just need to use ADODB to connect to SQL and just put the data on 300
pages
recursively.

Does this sound like a messy solution?

Thanks,
JP