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 / September 2006

Tip: Looking for answers? Try searching our database.

Want to print a separator page if a field equals a value

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike Gray - 07 Sep 2006 11:19 GMT
Hello. I've used Word 2000 many times to print mail merge letter projects.
The data source for all of these has been presorted mailing data created by
PostalSoft. I typically export the presorted data and save it in an Excel xls
format. In addition to normal name, address, city, state etc fields, the data
also includes breakmarks (usually "#" or "##"). The breakmark fields are only
populated if the record is for a mailpiece that is the first piece in a new
package or container of mail. Typical quantity for these jobs is 5,000 to
50,000 letters. They are printed on an HP9000 LaserJet using a PostScript
driver.
I'd like to be able to print a different colored separator sheet (pink,
pulled from a different paper tray) if the breakmark field equals "#" or
"##". This would allow other employees downstream of me to quickly identify
the start of new packages and containers as they perform folding and
inserting operaions. Is this possible with some sort of IF statement? Might
it require some other statement specific to the printer/driver?
Any help or additional sources of information would be greatly appreciated.
Peter Jamieson - 07 Sep 2006 12:16 GMT
In princiuple you may be able to do this using an IF field, a section break,
and File|Page Setup to apply the correct section formatting to each section,
but I'm not in a good position to test with a real printer and you may find
that it is difficult to set it up to produce the section formatting you
expect. But roughly speaking you would do this:

Insert the following nested IF field

{ IF "{ MERGEFIELD "<breakmark>" }" = "#" "<section break>" "" }

Use ctrl-F9 to insert the braces {}
Use the name of your breakmark field instead of <breakmark>
Use Insert|Break to insert an actual section break where I have put <section
break>

Use the mailmerge toolbar to navigate to a record where the breakmark is
"#", then use File|Page Setup to set up the paper tray for each section.

Then test with a small amount of test data. I couldn't really get it right
here when testing output to a new document - the section formatting seemed
to come out the wrong way around. But perhaps you will spot a way.

Depending on exactly what you are doing you may
a. have to use a "catalog" type merge instead of a "letters" type merge,
and explicitly insert a section break at the end of your mail merge main
document
b. be able to use page breaks and different formatting for the first and
for subsequent  pages instead of section breaks.

Another approach which may work since you're using a Postscript driver is to
use a PRINT field within the IF field. The PRINT field is supposed to send a
snippet of Postscript to the printer if the version of Windows and the
driver allows it - you use

{ PRINT "the postscript" }

but then you have to work out exactly what Postscript to send, and so on. If
you go this route, you should lookup the full definition of the PRINT field
in Word Help.

Peter Jamieson

> Hello. I've used Word 2000 many times to print mail merge letter projects.
> The data source for all of these has been presorted mailing data created
[quoted text clipped - 20 lines]
> Any help or additional sources of information would be greatly
> appreciated.
 
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.