adding a page break as a result of an IF statement

[crasmussen]

I have searched and searched -- not finding my answer.

Maybe someone here can help!

During a merge, I need to do a page break if a certain condition is
true. What code do I enter to get a page break?

I then also wondered if it was possible to call a VBA subroutine in the
middle of a merge as a result of an IF condition...?

-Chris R
(e-mail address removed)

 

[Charles Kenyon]

To clarify, do you need a manual page break (generally undesirable) or do
you need text on a new page. If the former, pressing Ctrl-Enter produces a
page break and I don't know if this works within an IF field but have no
reason to think it will not. Paragraph marks work (sort of) within IF
fields.

If you need text on a new page, format that text using paragraph formatting
of page break before and include that formatted text within your IF field.

 

[crasmussen]

Yes, I want a manual page break. The problem is this: I am producing
labels for kids at several schools via a mail merge. The data source
has all the kids lumped together. If I do a straight mailmerge, I get
School B's labels beginning to print in the middle of the page where
School A's labels ended.

I tried putting a Ctrl-Enter in the merge field, that didn't work.