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

Hi ?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 :-)