Snytax for CompareTo Field IF THEN ELSE

[seno]

Hi my first post woohoo,

I use mail merge in the work I do but wish to know what is syntax I us
for IF ELSE THEN statment. Hope fully it reads clearly.

Excel sheet
Field Trust_name
1 Plantation
2 The Cabbage

In the form letter, [ ] is where i want the sentence to chang
depending on the condition of the Trust_name. Example listed below.

"...as trustee for [ ] <<Trust_name>> Trust,..."

The statement I inserted [ ] in Word is:
IF FieldName:Trust_name Comparison:EqualTo CompareTo:"The..."
THEN "blank"
ELSE "the"

Result I want is:
1 Plantation "...as trustee for the Plantatio
Trust,..."
2 The Cabbage "...as trustee for The Cabbage Trust,..."

What I want to know is what is the correct syntax to use for CompareT
box:
"The-SPACE-Any number of character there after" for the compar
CompareTo box?

I guessed and tried "The*" doesn't work.

It cant be "The-Any number of character there after" as there word
begin with The such as Thespian and Theodore for example.

I hope theres an answer.
I pray in the mean time.

Cheers!
Sen

 

[Graham Mayor]

If I understand you correctly, what you require is

"...as trustee for { IF { MERGEFIELD Trust_name } <> "The *" "The "}{
MERGEFIELD Trust_name }Trust,..."

You can type this from the keyboard using CTRL+F9 for the field bracket
pairs
The wildcard does work if used as shown. Note the spaces.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>