[Bill B.]

How do I get rid of an extra space when I do a mail merge and there is no
middle initial?

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

[Rich/rerat]

Bill and Doug,
I use "switches" in the mergefields to make things a little Simpler, if
there is no {Mergefield Title} field.

{ MERGEFIELD FirstName}{ MERGEFIELD MiddleInitial \b " "}{ MERGEFIELD
LastName \b " "}

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate


"Doug Robbins - Word MVP" wrote in message
...
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?

[Doug Robbins - Word MVP]

Live and learn. Thanks.

--
Regards,
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Rich/rerat" wrote in message
...
Bill and Doug,
I use "switches" in the mergefields to make things a little Simpler, if
there is no {Mergefield Title} field.

{ MERGEFIELD FirstName}{ MERGEFIELD MiddleInitial \b " "}{ MERGEFIELD
LastName \b " "}

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate


"Doug Robbins - Word MVP" wrote in message
...
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?

[Rich/rerat]

Doug,
You are quite welcomed.

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate


"Doug Robbins - Word MVP" wrote in message
...
Live and learn. Thanks.

--
Regards,
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Rich/rerat" wrote in message
...
Bill and Doug,
I use "switches" in the mergefields to make things a little Simpler, if
there is no {Mergefield Title} field.

{ MERGEFIELD FirstName}{ MERGEFIELD MiddleInitial \b " "}{ MERGEFIELD
LastName \b " "}

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate


"Doug Robbins - Word MVP" wrote in message
...
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?