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

Tip: Looking for answers? Try searching our database.

adding a page break as a result of an IF statement

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
crasmussen@nc.rr.com - 17 Feb 2005 21:07 GMT
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
crasmussen@rti.org
Charles Kenyon - 17 Feb 2005 21:48 GMT
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.
Signature


Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

>I have searched and searched -- not finding my answer.
>
[quoted text clipped - 8 lines]
> -Chris R
> crasmussen@rti.org
crasmussen@nc.rr.com - 17 Feb 2005 22:17 GMT
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.
 
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.