can we call data for mail merge from two databases

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

APBM - 20 Jan 2006 06:47 GMT

I have one word document. For mail merge purpose I want to call data from two
excel sheets. For example i want to call Name and Address of the clients from
one Excel sheet and transactions details from another excel sheet. Is it
possible to do so? if yes, How?

Reply to this Message

Cindy M -WordMVP- - 20 Jan 2006 16:48 GMT

Hi =?Utf-8?B?QVBCTQ==?=,

> I have one word document. For mail merge purpose I want to call data from two
> excel sheets. For example i want to call Name and Address of the clients from
> one Excel sheet and transactions details from another excel sheet. Is it
> possible to do so?

Not directly, no. Are the transaction details in an one-to-many relationship
with the addresses - IOW could there be more than one item listed?

If that's the scenario we're looking at, go to the Mail Merge FAQ on my website
and look in the "Special merges" section. There's a short discussion there about
one-to-many merges, with links to sample documents for the three basic
approaches you can use. The one that should work for you is the Database field
method.

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