Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2007

Tip: Looking for answers? Try searching our database.

Merging from multiple datasources into 1 document

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Minnie - 27 Dec 2007 01:08 GMT
We have three separate databases with information we need entered into 1
document.  Is this possible?  If so, how do you do it?  We want to be able to
select a doctor from one DB, a dentist from another,  and a school from a
third and show them on our form.
Signature

Thanks!, Minnie

Peter Jamieson - 27 Dec 2007 01:34 GMT
Out of the box, Word's Mailmerge facility can only really use a single
datasource - in essence a single table of data. But if for example you are
trying to use MailMerge to produce one docu ent per person, and you have
data that specifies for each "Person ID" the doctor, the dentist, and the
school, you may be able to define a query or view that brings all the
relevant data together. That also depends on how the data is stored  - e.g.
if it is in separate Access tables in the same Access database, as long as
there is a suitable link, defining such a query may be fairly
straightforward. If it is in different tables in different Access databases,
or in completely different types of data source, it is likely to be much
more difficult.

You /might/ also be able to create a mailmerge that brings in the data from
/one/ of your sources, then use DATABASE fields to get data from the other
sources. Again, the feasibility and difficulty depends on the data sources
and the kind of data you need to retrieve.

Or if you can get the data using Access, you may be better off defining an
Access report to produce the output you need.

If you can give us some idea of the structure and location of the data you
are trying to retrieve it might be easier to be a bit more specific. It's
always handy to know what version of Word you are using, too.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> We have three separate databases with information we need entered into 1
> document.  Is this possible?  If so, how do you do it?  We want to be able
> to
> select a doctor from one DB, a dentist from another,  and a school from a
> third and show them on our form.
ChrisHarrington - 27 Dec 2007 04:35 GMT
Probably simplest solution would be to consolidate all data into a
spreadsheet and merge with that.

> We have three separate databases with information we need entered into 1
> document.  Is this possible?  If so, how do you do it?  We want to be able
> to
> select a doctor from one DB, a dentist from another,  and a school from a
> third and show them on our form.
tedmi - 31 Dec 2007 13:45 GMT
A more robust approach, which avoids the problems of creating a redundant
copy of the data, is to write a query that extracts data from the various
databases, and the query as an input table to the merge
Signature

TedMi


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.