![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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 |
| Ads |
|
#2
|
|||
|
|||
|
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
|
|||
|
|||
|
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 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change Location of Open Data Sources | Mary | Mailmerge | 4 | March 7th 06 07:59 PM |
| My Data Sources - Can not COPY file | Brenda | Mailmerge | 1 | February 19th 06 05:04 PM |
| Mail merge using two data sources in same document | Mommasbroke | Mailmerge | 5 | December 10th 05 08:59 AM |
| How do keep blank lines when merging a document with the data and. | ftroop | Mailmerge | 1 | March 30th 05 04:27 PM |
| MailMerge Data Sources | Bill S. | Mailmerge | 1 | January 8th 05 10:07 AM |