Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2006

Tip: Looking for answers? Try searching our database.

Start next record after varying no of pages?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
pQp - 08 Aug 2006 12:16 GMT
I have a merge doc which is 6 pages long that invites customers to enter a
competition.  The first couple of pages are common to all records then the
following 4 are one page entry forms depending on how many products the
customer has registered. (They are allowed one entry per product.) Each page
says "Entry 1 of (field -number of products registered)", "Entry 2 of
...".etc up to 4 entry pages.

At he moment, I just print the whole 6 and throw out the extra entry form
pages if they are entitled to less than that. (Very guilty about the waste!)

Is there a way to start the next record after the right amount of pages?
I tried using - next record if - the (no of products registered) field is
equal to 1, at the end of entry form page one, then 2 on page two etc, but
this simply continues with the next record from that page, it doesn't start
the next record from the beginning. eg: if Joe Blogg's is supposed to stop
at 2, after two entry form pages, all four are still printed, but the last 2
forms are labelled for the next customer.

Can anyone help? Thankyou.
Graham Mayor - 08 Aug 2006 13:21 GMT
You need to do this the other way round and insert the pages only as
required. You can do this with IncludeText fields or Autotext fields that
contain the page information.

Entry 1 of { MERGEFIELD NumberFieldName }¶

{ IncludeText "C:\\Path\\Filename.doc" }{ IF{ MERGEFIELD NumberFieldName } =
2 "Entry 2 of { MERGEFIELD NumberFieldName }¶

{ IncludeText "C:\\Path\\Filename.doc" }" }{ IF{ MERGEFIELD
NumberFieldName } = 3 "Entry 2 of { MERGEFIELD NumberFieldName}¶

{ IncludeText "C:\\Path\\Filename.doc" }Entry 3 of { MERGEFIELD
NumberFieldName }¶

{ IncludeText "C:\\Path\\Filename.doc" }"}{ IF{ MERGEFIELD NumberFieldName }
= 4 "Entry 2 of { MERGEFIELD NumberFieldName }¶

{ IncludeText "C:\\Path\\Filename.doc" }Entry 3 of { MERGEFIELD
NumberFieldName }¶

{ IncludeText "C:\\Path\\Filename.doc" }Entry 4 of { MERGEFIELD
NumberFieldName }¶

{ IncludeText "C:\\Path\\Filename.doc" }" }¶

NumberFieldName is the field that holds the number 1 to 4

c:\\path\\filename.doc is the entry document.

¶ is where you press enter.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have a merge doc which is 6 pages long that invites customers to
> enter a competition.  The first couple of pages are common to all
[quoted text clipped - 15 lines]
> next customer.
> Can anyone help? Thankyou.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.