Word field with If then else

[simonc]

First, I'm using Word 2000 which might limit my options.

My data is in a spreadsheet. In the merged word document I want to insert or
not insert an address based on the first three characters of a field in the
spreadsheet.

ie something like: if first three characters of field Client = XYZ then put
in the address of client XYZ, otherwise leave blank.

Unfortunately, in the If then else dialogue the only options for comparison
are numerical - equal, less than etc. Is there a way of putting in a
condition related to a text field?

Grateful for advice.

 

[Peter Jamieson]

You may be able to get away with an IF field that looks something like this:

{ IF "{ MERGEFIELD Client \*Upper }" = "XYZ*" "{ MERGEFIELD Address }" "" }

- use ctrl-F9 to insert each pair of the special field braces {}, then type
everything else as text.

 

[simonc]

Many thanks for this. It worked a treat.