One Single Main Document, Multiple Data Sources?

[Bruce Chao]

MS Access 2000/MS Word 2000.

I need to create a Word mail merge -- the Word file is a sinlge document
but in the word file, I need to retrieve data from multiple data sources.

For example, on the top half of the word file, I need to retreieve data
using QueryA; the bottom half of the word file, I need to retrieve data
using QueryB.

Question: Can a mail merge invlove more than data sources? (or, can I
use more than one data sources in one word document) If that's possible,
how do I do that?

Thanks!

 

[Cindy M -WordMVP-]

Hi Bruce,

Strictly speaking, what you want isn't possible. IF, however, the
additional sets of data may be displayed in table format you can use a
DATABASE field to link it in, and even link it to the individual data
sources.

In the Mail Merge FAQ on my website, Special Merges section, you'll find a
discussion on how to approach "one-to-many" merges. There are links to
sample files, including one for the DATABASE field. See if you can use
that?

If that isn't appropriate, please describe in more detail what you need.

MS Access 2000/MS Word 2000.

I need to create a Word mail merge -- the Word file is a sinlge document
but in the word file, I need to retrieve data from multiple data sources.

For example, on the top half of the word file, I need to retreieve data
using QueryA; the bottom half of the word file, I need to retrieve data
using QueryB.

Question: Can a mail merge invlove more than data sources? (or, can I
use more than one data sources in one word document) If that's possible,
how do I do that?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Bruce Chao]

Thank you so much Cindy. I definitely will look into your web site!