View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default Merging Excel File into Word

See http://support.microsoft.com/?kbid=294686

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


BigBuck98 wrote:
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