Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Want to print a separator page if a field equals a value
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Want to print a separator page if a field equals a value
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 "Mike Gray" Mike wrote in message ... 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trying to get Word to print field bookmarks in a form. | Page Layout | |||
Field swallows my characters | New Users | |||
Print field problem | New Users | |||
Having multiple form fields automatically updated | Microsoft Word Help | |||
Text Form Field Ref in Footer Won't Update on Screen | Microsoft Word Help |