View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default multiple records repeat in one doc

Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

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

http://www.knowhow.com/Guides/Compou...poundMerge.htm

Or do it with a report in the database - probably what I would do if I were
you.

--
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

"flnew" wrote in message
oups.com...
Hi gurus,
I have a word doc like below:
Xxxxx xxxxx xxxxx xxx xxxx, xxxxxxxxxxxx xxxxxxxxxx xxxx, xxx xxxx
xxxxxxx
xxxxxxxx xxxx xx xxxxxxx xx xx xxxxxxx xxxxxxxxx.

{mergefield fieldname1}
{mergefield fieldname2}
{mergefield fieldname3}
{mergefield fieldname4}
{mergefield fieldname5}

{NEXT}{mergefield fieldname1}
{mergefield fieldname2}
{mergefield fieldname3}
{mergefield fieldname4}
{mergefield fieldname5}

Xxxxx xxxxx xxxxx xxx xxxx, xxxxxxxxxxxx xxxxxxxxxx xxxx, xxx xxxx
xxxxxxx
x.

I need to repeat these fieldname1 to 5 depend on the number of records
returned from database. The number of records is change each time. So I
can not use NEXT because I do not know how many NEXT I need. Can
someone please help me with this? Thank you very much for your help in
advance!