Please Help - Useing Word 2000.
I have the MergeFields Title, Firstname & Lastname in a letter but if there
is no information in the fields I need to have the Company name.

Can I use a If{ Mergfield TITLE} = " " ,"{Mergfield COMPNAME}",{Mergfield
TITLE}"} statement with the merge fields.

IF TITLE ,FIRSTNAME & LASTNAME = ISNULL THEN MEGRFIELD COMPNAME
The merge fields a from a CSV File.

Thanks
Peter

It seems likely that the lastname field is the important one to use for this
condition thus:

{ IF { Mergefield LastName } = "" "{ Mergefield CompName }" "{Mergefield
Title} { Mergefield FirstName } { Mergefield LastName }" }

will insert the company name if the lastname field is empty, otherwise the
other three fields)

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Peterg wrote:
Please Help - Useing Word 2000.
I have the MergeFields Title, Firstname & Lastname in a letter but if
there is no information in the fields I need to have the Company name.

Can I use a If{ Mergfield TITLE} = " " ,"{Mergfield
COMPNAME}",{Mergfield TITLE}"} statement with the merge fields.

IF TITLE ,FIRSTNAME & LASTNAME = ISNULL THEN MEGRFIELD COMPNAME
The merge fields a from a CSV File.

Thanks
Peter

Hi Peter,

Presumably, if the LastName is empty, so too would be the FirstName and
Title. In that case, a field coded as:
{IF{MERGEFIELD LastName} = "" {MERGEFIELD CompName}}
would do.

Cheers


"Peterg" wrote in message
...
Please Help - Useing Word 2000.
I have the MergeFields Title, Firstname & Lastname in a letter but if
there
is no information in the fields I need to have the Company name.

Can I use a If{ Mergfield TITLE} = " " ,"{Mergfield COMPNAME}",{Mergfield
TITLE}"} statement with the merge fields.

IF TITLE ,FIRSTNAME & LASTNAME = ISNULL THEN MEGRFIELD COMPNAME
The merge fields a from a CSV File.

Thanks
Peter