merging 2 data sources

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pumpkin4455 - 27 Apr 2006 14:26 GMT

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

Reply to this Message

Peter Jamieson - 27 Apr 2006 15:58 GMT

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

> I'm trying to create a mail merge to enter data from 2 different data
> sources
[quoted text clipped - 10 lines]
> providers
> names from another source. I have Microsoft XP Professional

Reply to this Message

pumpkin4455 - 27 Apr 2006 16:17 GMT

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

> 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
[quoted text clipped - 22 lines]
> > providers
> > names from another source. I have Microsoft XP Professional

Reply to this Message