Multiple Data Sources

[Mikki]

Does anyone know if you can use multiple data sources in a
mail merge document? For example, info from more than one
Access table/query used in the same Word document.

 

[Cindy Meister -WordMVP-]

Hi Mikki,

Does anyone know if you can use multiple data sources in a
mail merge document? For example, info from more than one
Access table/query used in the same Word document.

It depends, really, on how what it is you mean, and what you
want.

Are you talking about two data tables that have basically the
same set up, and you want to merge all the records from both
(one after the other, so to speak)?

Or are you thinking about how to merge some kind of
one-to-many relationship? (Like you'd use a sub-report in an
Access report)

Or something else?

Please also tell us which version of word is involved.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 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

 

[MUSIWA]

-----Original Message-----
Hi Mikki,

It depends, really, on how what it is you mean, and what you
want.

Are you talking about two data tables that have basically the
same set up, and you want to merge all the records from both
(one after the other, so to speak)?

Or are you thinking about how to merge some kind of
one-to-many relationship? (Like you'd use a sub-report in an
Access report)

Or something else?

Please also tell us which version of word is involved.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 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

.
I am posting this to clarify the question since I have

had a simalar problem. In word if you merge a source and
in the next paragraph merge a different source the first
source is replaced by the second source. So if you have
merged feilds it will no longer work. Sow how do you
reference more than one source in the same main document.