Mail Merge Fields

[Peterg]

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

 

[Graham Mayor]

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


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

 

[macropod]

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