[Doug Robbins - Word MVP]

Insert the following mergefields

FirstName MiddleInitial MiddleInitial LastName LastName

Then press Alt+F9 to reveal the field codes and you will see:

{ MERGEFIELD FirstName } { MERGEFIELD MiddleInitial } { MERGEFIELD
MiddleInitial } { MERGEFIELD LastName }{ MERGEFIELD LastName }

Select everying thing except the { MERGEFIELD FirstName } and press Ctrl+F9
to insert a new pair of field delimiters around the selected items as
follows:

{ MERGEFIELD FirstName } { { MERGEFIELD MiddleInitial } { MERGEFIELD
MiddleInitial } { MERGEFIELD LastName } { MERGEFIELD LastName } }

Now, add IF, "", and the other quotation marks as shown below:

{ MERGEFIELD FirstName } { IF { MERGEFIELD MiddleInitial } "" "{
MERGEFIELD MiddleInitial } { MERGEFIELD LastName }" "{ MERGEFIELD
LastName }" }

Finally, press Alt+F9 to toggle off the display of the field codes.

--
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, originally posted via msnews.microsoft.com
"Bill B." wrote in message
...
How do I get rid of an extra space when I do a mail merge and there is no
middle initial?