Double blank when no middle name

[alan]

I have Word and Outlook 2002 SP2.

How do you avoid a double blank space when you select <<First Name>>
<<Middle Name>> <<Last Name>> when there is no middle name?

Alan

 

[Doug Robbins]

Use an If...then...Else field construction

{ MERGEFIELD FirstName } { IF { MERGEFIELD MiddleName }= "" "" "{ MERGEFIELD
MiddleName } "}{MERGEFIELD LastName}

Note that there is a space between the } and the " in the second instance of
{ MERGEFIELD MiddleName } "
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[macropod]

Or perhaps:
{MERGEFIELD FirstName} {IF{MERGEFIELD MiddleName}= "" {MERGEFIELD LastName}
"{MERGEFIELD
MiddleName} {MERGEFIELD LastName}"}

Cheers

 

[Graham Mayor]

Or even

{ Mergefield FirstName }<space>{ IF{ Mergefield MiddleName } <> "" "{
Mergefield MiddleName }<space>" }{ Mergefield LastName }