Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
pumpkin4455
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
pumpkin4455
 
Posts: n/a
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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


All times are GMT +1. The time now is 12:12 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"