[Jesse]

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

[Doug Robbins - Word MVP]

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

[Jesse]

Thanks very much for the help. It is always good to know that a
direct solution is _not_ available -- so I can stop looking in Word
2000. The links were helpful and gave me some ideas.

It would seem that I could insert my top text (before the merged data
from the db) with an IF statement testing for MERGESEQ=1.

Do you know if there is a length limit to a results text string in an
IF statement? Also, is there a way to get a carriage return into the
text string?

Unfortunately, I could not find a way to test for the last record --
so I could say: IF last record, print "text". If I am wrong about
testing for the last record, please let me know.

Ultimately, maybe the easiest answer for my specific situation is to
create a macro to insert the top-of-doc and end-of-doc text blocks
after running the merge. One more button to push.

Again, thanks. -- Jesse


On Sun, 16 Jul 2006 07:45:35 +0200, "Doug Robbins - Word MVP"
wrote:

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