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

Tip: Looking for answers? Try searching our database.

Using IF and OR

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brenda A. Reid - 12 Feb 2008 15:38 GMT
I have a template that askes this question:

{ set restrictions { FILLIN  "Are there any restrictions on objects?  [ y /
n ]" \* MERGEFORMAT }}

Because of the fillin field answer being case sensitive, I'd like to be able
to simplify my coding.  Would like to be able to say something like this:

{ if restrictions = n OR N "There are no restrictions on the objects and
powers of the Company." "Restrictions on the objects and powers of the
Company are as set forth in Schedule "A" hereto."  \* MERGEFORMAT }

How  would I do it if it's at all possible?  Also, how would I use quotes
within quotes, i.e. Schedule "A" in the second part of the response?

Tks . . .
Peter Jamieson - 12 Feb 2008 17:55 GMT
In this case the simplest thing is something like

{ IF "{ REF restrictions \*Upper }" = "N" "There are no...."
"Restrictions..." }

For the double quotes within the IF result text, there are a few options,
e.g.
a. use two single quotes
b. use { QUOTE \" }
c. use { SET q { QUOTE \" } } at the beginning of your document and { q }
(or { REF q }) when you need a "

(make sure each pair of {} are the special field braces you can insert using
ctrl-F9).

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>I have a template that askes this question:
>
[quoted text clipped - 13 lines]
>
> Tks . . .
Brenda A. Reid - 12 Feb 2008 20:00 GMT
Worked great -- ever so greatful . . .
Brenda

> In this case the simplest thing is something like
>
[quoted text clipped - 28 lines]
>>
>> Tks . . .
 
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.