multiple records repeat in one doc

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

flnew - 13 Jun 2006 18:14 GMT

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!

Reply to this Message

Doug Robbins - Word MVP - 13 Jun 2006 19:36 GMT

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

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

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

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

> Hi gurus,
> I have a word doc like below:
[quoted text clipped - 23 lines]
> someone please help me with this? Thank you very much for your help in
> advance!

Reply to this Message

flnew - 13 Jun 2006 20:16 GMT

Doug, thank you very much for your help!
What do you mean "multiple items per condition (=key field)" ? I do not
have any condition in the doc. I just want to repeat all the returned
record in one doc rather than usually multiple doc.
The logical like:
if next record exists
then
{mergefield fieldname1}
{mergefield fieldname2}
{mergefield fieldname3}
{mergefield fieldname4}
{mergefield fieldname5}

until end of file. So you think it's not possible to do it? Thanks for
your help!

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

Reply to this Message

flnew - 13 Jun 2006 21:52 GMT

Use the directory in mail merge works perfect. But the problem is there
is some text do not need to repeat so how can i use directory only part
in the main document? Thanks for help in advance!

Reply to this Message

Doug Robbins - Word MVP - 14 Jun 2006 04:52 GMT

You have to add the additional text after executing the merge.

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

> Use the directory in mail merge works perfect. But the problem is there
> is some text do not need to repeat so how can i use directory only part
> in the main document? Thanks for help in advance!

Reply to this Message

flnew - 14 Jun 2006 15:50 GMT

Thanks!
So there is no way that word do the job for me? That's just not
acceptable for user to put text after the merge.

Is there any other work around? Thanks!

> You have to add the additional text after executing the merge.
>
[quoted text clipped - 9 lines]
> > is some text do not need to repeat so how can i use directory only part
> > in the main document? Thanks for help in advance!

Reply to this Message

Doug Robbins - Word MVP - 14 Jun 2006 19:06 GMT

See some of the information on Cindy's website to which I directed you.

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

> Thanks!
> So there is no way that word do the job for me? That's just not
[quoted text clipped - 15 lines]
>> > is some text do not need to repeat so how can i use directory only part
>> > in the main document? Thanks for help in advance!

Reply to this Message

flnew - 14 Jun 2006 21:35 GMT

Thanks! I did research Cindy's site you posted but it seems none of
them working for me. Thanks for your help!

Reply to this Message

Rate this thread: