[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.

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

"simonc" wrote in message
...
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.

[simonc]

Many thanks for this. It worked a treat.