[Graham Mayor]

You could use a SKIPIF field - {SKIPIF {Mergefield fieldname} = "0"}

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Frank wrote:
I have made an Excel sheet with data pulled from other sheets. Some
of the entries have "0's" on them, which is fine in Excel, but I
don't need to print out Envelopes with "0's" on them in Mail Merge.
I know how to manually filter them out in Word during the select
recipients part, but is there a way that I can automate this. I have
set my Excel sheet as a template because the data is always new, and
I also have a template of the envelope with the formatting and merge
fields already in place. Is it possible to save filtering process
steps? Currently we have to click on one of the field arrows in
"Select Recipient" dialog box, select advanced, then we select the
field to be filtered, choose the comparison by option (we use
"Greater Than") and then enter the "0" zero. This gets rid of all
the entries we don't need, but is there a way that I can save that
into the Envelope Template or something? Maybe even in Excel? I
appreciate any help on this. Thanks.