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 / May 2008

Tip: Looking for answers? Try searching our database.

"IF" Statement and Multiple Conditions

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PMS - 20 May 2008 13:53 GMT
I've been using this feature for a very long time. I can't seem to figure
this one out. I'm using Word 2003. I have a document that requires another
document be inserted. The conditions are only for states AL, AZ, IL, IN OR MI
({MERGEFIELD RISK_STATE}) AND if the line of business {MERGEFIELD LOB} is EP,
NP OR HO. Help! Thanks, PS
Doug Robbins - Word MVP - 20 May 2008 20:37 GMT
The easiest thing will be to set up a nested If...then...Else construction
for each state

{ IF { MERGEFIELD RISK_STATE } = AL { IF { MERGEFIELD LOB } = EP {
INCLUDETEXT "DRIVE:/PATH/FILENAME" } "" } "" }

and repeat this with no space between each of the above field constructions
for each of the other states.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I've been using this feature for a very long time. I can't seem to figure
> this one out. I'm using Word 2003. I have a document that requires another
[quoted text clipped - 3 lines]
> EP,
> NP OR HO. Help! Thanks, PS
PMS - 21 May 2008 12:27 GMT
That's what I thought. Thanks for your assistance. PS

> The easiest thing will be to set up a nested If...then...Else construction
> for each state
[quoted text clipped - 12 lines]
> > EP,
> > NP OR HO. Help! Thanks, PS
 
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.