Using mailmerge functionality for non-mailing uses...

[chefchick]

I'm trying to figure out how I can use the data from an Excel spreadsheet to
feed several different Word docs, for purposes not related to a mailing (just
trying to save on data entry). I'd like it so that when I enter a the name
of an item in my spreadsheet, the item name also appears in a specified place
in each of two different Word docs. Possible? Been poking around without
much success. Thanks.

 

[chefchick]

I should have added an example of what I want the Word docs to do - for
instance, if the spreadsheet contains a list of items sold, the Word doc
might be a letter confirming the items sold to one person. The spreadsheet
might have pencils, books, and paper listed as data items; the Word doc might
use that data like this:

"Congratulations! Today you purchased pencils, books, and paper."

A second doc would be labels, one of each consisting of the item sold - so
one label each for pencils, books, and paper.

Any help appreciated; thanks!