I am helping with a fundraiser for a local Little League. They are selling
57 items in their fundraiser. I have a database in Excel that shows the
players names that have sold items, plus all the items that are available
and also the number of the various items that each player has sold.
I am using Word and Excel 97. In Word I have set up a form letter and
inserted the mail merge fields and also have a product name to go with each
of the fields.
I understand how to do the merge, but since most players only sell at the
most 10 different items and rather that having it print all 57 items on the
form letter with only amounts in the product that was sold is there a way to
only have it print the products that have an amount sold.
Thanks,
Gordon