View Single Post
  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Prevent mail merge from leaving a space when there is no data.

No,

You need to use

{Mergefield First_Name}[no space]{IF{Mergefield Initial} ""
"[space]{Mergefield
Initial}"}[space]{Mergefield Last_Name}


Where you have a space where indicated by [space] and you do not have a
space where the [no space] appears.

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

"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!