merge into middle of Word doc - non-repeating text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jesse - 16 Jul 2006 00:09 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 16 Jul 2006 06:45 GMT

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/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

or look at:

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

Signature

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

>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
[quoted text clipped - 25 lines]
> How can I do this efficiently with Wod and Excel? Can it be done?
> Thanks. -- Jesse

Reply to this Message

Jesse - 16 Jul 2006 22:50 GMT

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

>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.
[quoted text clipped - 11 lines]
>
>http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

Reply to this Message