Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
multiple records repeat in one doc
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! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
multiple records repeat in one doc
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! Doug Robbins - Word MVP wrote: 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: |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
multiple records repeat in one doc
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! |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
multiple records repeat in one doc
You have to add the additional text after executing the merge.
-- 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 ps.com... 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! |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
multiple records repeat in one doc
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! Doug Robbins - Word MVP wrote: You have to add the additional text after executing the merge. -- 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 ps.com... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple records on 1 page | Mailmerge | |||
Email Print Merge with multiple records in the document | Mailmerge | |||
Multiple Records Same Page | Mailmerge | |||
Multiple records into a single document | Mailmerge | |||
How do I get multiple Access records into a single mailmerge lett. | Mailmerge |