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 / March 2005

Tip: Looking for answers? Try searching our database.

Testing mergedata to prevent printing a document

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JohnD - 30 Mar 2005 17:11 GMT
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?
larrynospam@nospamjbmsystems.com - 30 Mar 2005 19:06 GMT
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.
Cindy M  -WordMVP- - 31 Mar 2005 18:57 GMT
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 :-)

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.