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

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!