Does anyone know of a way to test data in a mergefield and prevent printing
the document if data matches the tested criteria. I have tried an if
statement with STOP as what to do if the criteria are met but
unfortunately this doesn't work. Any ideas?

--
Message posted via http://www.officekb.com

Hi,

OctoTools, a commercial document management software, has this capability
and could be justified if you have a medium to high volume application or
need an automated solution. Let me know if you have any interest. Phone
(978) 535-7676 (Boston, MA USA) or e-mail larry at jbmsystems dot com

Larry T.

Hi JohnD,

Does anyone know of a way to test data in a mergefield and prevent printing
the document if data matches the tested criteria. I have tried an if
statement with STOP as what to do if the criteria are met but
unfortunately this doesn't work.

Well, you could set a QueryOption to simply suppress any records that meet
the criterium...

Other than that, you'd need to use VBA to test the data before allowing the
merge to execute. Or, perhaps even better, check the data before allowing it
to be connected to the main merge document, which would prevent the user from
printing the main merge document, itself, with data displaying.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)