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?