One Single Main Document, Multiple Data Sources?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bruce Chao - 22 Dec 2003 21:11 GMT

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!

Reply to this Message

Cindy M -WordMVP- - 23 Dec 2003 10:02 GMT

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.
>
[quoted text clipped - 8 lines]
> 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 :-)

Reply to this Message

Bruce Chao - 23 Dec 2003 20:22 GMT

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

Cindy M -WordMVP- wrote:

> Hi Bruce,
>
[quoted text clipped - 30 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)

Reply to this Message