how do I force page break in multi record per page mail merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alleycatinet - 30 Oct 2004 18:20 GMT

I am merging 7 records on a page, but want to start a new page at a change in
area codes. I can force a break but the last record on the prev page repeats
until the end of the page. That happens when I use NEXTIF. If I use NEXT and
SKIP, the entire prev page doesn't print.

The docs say use Query statements instead of NextIf in this version. But
they don't allow a page break either.

If I knew what the Page Break code was I may be able to use an IF THEN ELSE.
But the Page Break doesn't show even when I Alt-F9.

Reply to this Message

Graham Mayor - 31 Oct 2004 07:50 GMT

You can insert a page break in a conditional statement if you build the
statement manually using CTRL+F9 for the field boundaries eg

{IF {Mergefield Fieldname} = condition "insert a page break from the menu
here" }
However, this will not work unless you test for every possible alternative
that might crop up in your data file. You might investigate Cindy's web site
for suggestions -
http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#ComplexMerg

Signature

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

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

> I am merging 7 records on a page, but want to start a new page at a
> change in area codes. I can force a break but the last record on the
[quoted text clipped - 6 lines]
> If I knew what the Page Break code was I may be able to use an IF
> THEN ELSE. But the Page Break doesn't show even when I Alt-F9.

Reply to this Message