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