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

Tip: Looking for answers? Try searching our database.

Hide/show  mailmerge fields depending on value

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JoeG - 02 Aug 2004 14:09 GMT
Hi:

I'm trying to develope a mailmerge document to display a
report of items from a Access Query file. I've gotten the
simple stuff out of the way...mainly presenting 40 fields
in a table listing a brief discription of each "item".

NOW comes the difficut part.........

I'd like to describe in greater detail all items with a
certain value...say "High". In this "view" I'd like to
give more info in a small table for each item.

   Item: 1......40 (if trigger field is "too high")
Question: Question text goes here for reader's benefit.
Comment: Inspectors comments on this question.
Guidance: Text offering guidance on this question.

This will repeat for each item where the trigger value
equals "High".

I don't want to print lines where the trigger equals "low"
or "medium". I think a VB macro is the way to go but I'm
not sure.

Thanks for your help....Joe
Graham Mayor - 02 Aug 2004 16:40 GMT
A simple conditional field would do the trick:

{IF {Mergefield fieldname} = "High" "Type this"}

Signature

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

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

> Hi:
>
[quoted text clipped - 22 lines]
>
> Thanks for your help....Joe
 
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.