View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jesse Jesse is offline
external usenet poster
 
Posts: 2
Default merge into middle of Word doc - non-repeating text

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