merging 2 data sources

[pumpkin4455]

I'm trying to create a mail merge to enter data from 2 different data sources
into one document and cannot figure out how to do it....if it can be done. I
have a main document that I need name, address, etc entered. I then need
data entered for a doctor, address, etc. I need to be able to enter
different doctors names for the same client. ex: jane doe going to see dr
fox. But the next time I do this document for jane doe she's going to see
dr. wolf. I have created a data source with just client names and another
with just medical provider names. I can get the client names to merge but
can't get the document to hold with that until I enter the medical providers
names from another source. I have Microsoft XP Professional

 

[Peter Jamieson]

If you need to list multiple doctors names for the same client, Word isn't
very good at this kind of thing. You may be able to use one of
the approaches described on Cindy Meister's pages at

http://homepage.swissonline.ch/cindymeister/

- see Mailmerge FAQ, Special Merges, Multiple Items per condition.

If possible use an Access report.

Peter Jamieson

 

[pumpkin4455]

Thanks Peter. Not what I wanted to hear though ! I'll check out Cindy's site
and see what I can come up with.