multiple databases?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sallyt - 06 Jun 2004 08:57 GMT

Is it possible to create a mail merge doc attached to
several databases or does it have to be just one? Ta
Sally

Reply to this Message

Cindy M -WordMVP- - 06 Jun 2004 11:26 GMT

Hi Sallyt,

> Is it possible to create a mail merge doc attached to
> several databases or does it have to be just one?

Mail merge can be attached to only one.

If you're trying to display a table of data within a merge
document, you can use a DATABASE field (Database toolbar,
Insert database button) to do so, however.

Perhaps if you explain in a bit more detail what you want
to accomplish?

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

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

- 06 Jun 2004 12:12 GMT

Thanks Cindy

No, not display data within, just attach and merge to
several databases, which obviously cannot be done. Many
thanks for replying!
Sall

>-----Original Message-----
>Hi Sallyt,
[quoted text clipped - 22 lines]
>
>.

Reply to this Message

Cindy M -WordMVP- - 07 Jun 2004 15:34 GMT

> just attach and merge to
> several databases, which obviously cannot be done.

Well, depending on the data source, there might be a way to
work around it... (For example, in Access I could use a
Union query to link tables. Something similar can be done
with Excel in MS Query.)

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

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

I Am Cdn - 08 Jun 2004 03:11 GMT

I have the same question come up today.
Mail merge Word template shows an invoice #, # of cartons
shipped, destination address and telephone number.

Database1= each store's address / tel # with a unique
store ID

Database2 = invoice #, # of cartons shipped and same
unique ID for a store applies.

Can the mail merge doc look into Database2 for the Unique
ID and based on that ID# pull in the address / tel # from
Database 1 and the invoice # and # of cartons shipped from
Database2?

Thanks muchly!

>-----Original Message-----
>Is it possible to create a mail merge doc attached to
>several databases or does it have to be just one? Ta
>Sally
>.

Reply to this Message

Doug Robbins - Word MVP - 08 Jun 2004 06:13 GMT

The answer is the same, only one datasource can be used. In your case
however, a simple select query in Access can be used to combine the data
from the two tables by linking them on the ID field and you can then use
that query as the datasource.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I have the same question come up today.
> Mail merge Word template shows an invoice #, # of cartons
[quoted text clipped - 18 lines]
> >Sally
> >.

Reply to this Message