You are trying to perform what amounts to a "multiple items per condition
(=key field)" mailmerge which Word does not really have the ability to do.
The easiest thing is probably just to copy and paste the information from
Excel in the Word document. However see the "Group Multiple items for a
single condition" item on fellow MVP Cindy Meister's website at:
http://homepage.swissonline.ch/cindy...faq1.htm#DBPic
Or take a look at the following Knowledge Base Article:
http://support.microsoft.com/default...b;en-us;211303
or look at:
http://www.knowhow.com/Guides/Compou...poundMerge.htm
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Jesse" wrote in message
...
I am using Word & Excel 2000. I need to merge records from an Excel
file into the middle of a word document. I need to run this every
day.
The problem I am having is that I cannot figure out how to get the
mail merge function to _not_ repeat the text I only want appearing
above and below the repeating data.
As an example of what I want:
___
Today's results are in for eveyone who ran the 100 yard dash. Here is
the list and the times for each runner.
[repeating data begins]
Name: name Time: time
[end repeating data]
We will post the results every day as soon as we get them from the
coach.
Thanks.
____
How can I do this efficiently with Wod and Excel? Can it be done?
Thanks. -- Jesse