View Single Post
  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default Prevent mail merge from leaving a space when there is no data.

In Word 2003 you can try

{ MERGEFIELD First_Name }{ MERGEFIELD Initial \b " " } { MERGEFIELD
Last_Name }

(i.e. there is a space between the 2nd and third fields) or even

{ MERGEFIELD First_Name }{ MERGEFIELD Initial \b " " }{ MERGEFIELD Last_Name
\b " " }

Peter Jamieson
"Donna123" wrote in message
...
Graham-I do use the individual fields, I.e. FName, MName, LName, etc...I
keep
getting blank spaces between FName and LName when there is no data
populating
the MName field in a record. Didn't there used to be a simple toggle
checkbox
for this option in Word prior to 2003? Sigh...Thank you.

"Graham Mayor" wrote:

Avoid using the AddressBlock field and use the individual fields of the
data
file eg

{Mergefield First_Name}{IF{Mergefield Initial} "" " {Mergefield
Initial}"} {Mergefield Last_Name}


--

Graham Mayor - Word MVP

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



Donna123 wrote:
When using mail merge in Word 2003, where is the setting you can
modify to prevent mail merge from leaving a space when there is no
data for a field? I.e., so mail merge does not leave an extra space
between a first and last name when there is no middle initial when
running name tags, etc... Thanks!