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 / April 2004

Tip: Looking for answers? Try searching our database.

Condition Statement

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cassy - 19 Apr 2004 17:48 GMT
I have a mail merge document where I want certain letters with a fiel
associated with it to print to a tray 1 and the other letters to wit
another merge field to print to tray 2.  How do I set my condition u
to do this when all the letters are in one document when it merges?
For example I have a 50 page document and I want pages 5, 10, 15 tha
has one merge field on it to go to tray 1 and pages 1,3,7,35,23,40an
50 to go to tray 2 based on the merge field and all other to go to tra
3.  These pages can be different based on the data source each time i
is merged
Graham Mayor - 20 Apr 2004 10:00 GMT
I don't think you will be able to do this using fields.

However, if your printer is an HP compatible laserjet you may be able to
send PRINT commands via a conditional field to switch the trays. I am not,
however, confident that it will work as part of the merge and I don't have
the printer available here to test it.

Also the actual commands vary between printers which is particularly
unhelpful, but if you can locate the bin escape sequences in your printer
handbook, something along the lines of the following - placed at the top of
the page - is worth a try

{IF {Mergefield Fieldname} = result1 "{PRINT 27"&l1H "}" "{IF {Mergefield
Fieldname} = result2 "{PRINT 27"&l2H "}" "{PRINT 27"&l3H "}"}

See also fellow MVP Jonathan West's excellent article on controlling
printers from vba -
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=101

You could also split the merge document into separate letters if that would
be useful - http://www.gmayor.com/individual_merge_letters.htm

Signature

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

  Web site www.gmayor.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I have a mail merge document where I want certain letters with a field
> associated with it to print to a tray 1 and the other letters to with
[quoted text clipped - 9 lines]
> ------------------------------------------------
> ~~ Message posted from http://www.WordForums.com/

Rate this thread:






 
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.