Merge data - save as different documents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jan - 16 Mar 2005 17:35 GMT

I am using Word 2003. I have a letter with merge fields and Excel is the
data source. The data source includes products by locations.
Is there a way to merge data for a specific product but save the data as
different files when the location changes. Currently, I am running the merge
separately for each location.

If yes, please explain because I don't have a clue as to how it can be done.

TIA

Reply to this Message

Cindy M -WordMVP- - 22 Mar 2005 22:31 GMT

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

> I am using Word 2003. I have a letter with merge fields and Excel is the
> data source. The data source includes products by locations.
> Is there a way to merge data for a specific product but save the data as
> different files when the location changes. Currently, I am running the merge
> separately for each location.

there's no way mail merge can do this for you, no. Something would probably be
possible using a macro...

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