Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
BigBuck98
 
Posts: n/a
Default Merging Excel File into Word

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


  #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



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
How to put graphics on envelopes? Steve Koenig Microsoft Word Help 21 April 29th 23 02:47 AM
Word should allow to 'divide' page by 3 or 4, not just 2 CandasK Page Layout 2 February 28th 06 11:16 PM
WP merge file to Word sstires Tables 4 February 14th 06 07:26 PM
How do I create & merge specific data base & master documents? maggiev New Users 2 January 13th 05 12:30 AM


All times are GMT +1. The time now is 10:23 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"