View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Remove extra space between first and last name when there is no mi

And instead of using the AddressBlock field use the individual fields in the
manner Doug has described.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Doug Robbins - Word MVP wrote:
You need to use and If...then...Else field construction

{ IF { MERGEFIELD Initial } "" "{ MERGEFIELD Initial } { MERGEFIELD
LastName }" "{ MERGEFIELD LastName }" }

You must use Ctrl+F9 to insert each pair of field delimiters { } and
you use Alt+F9 to toggle off their display.


"Jillie" wrote in message
...
I have tried everything. I did a mail merge in Word and cannot seem
to remove the extra space between the first and last name in the
address block
on the letter when no middle initial is available.

My data fields are FirstName, MiddleInitial, LastName and some
people do not
have a middle initial so that field is blank for them in the data
source. When it prints, the people without a middle initial have two
spaces
between
their first and last names! Please help. thank you.