Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merging 2 data sources
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merging 2 data sources
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" wrote in message ... 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merging 2 data sources
Thanks Peter. Not what I wanted to hear though ! I'll check out Cindy's site
and see what I can come up with. "Peter Jamieson" wrote: 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Location of Open Data Sources | Mailmerge | |||
My Data Sources - Can not COPY file | Mailmerge | |||
Mail merge using two data sources in same document | Mailmerge | |||
How do keep blank lines when merging a document with the data and. | Mailmerge | |||
MailMerge Data Sources | Mailmerge |