 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2006Prevent mail merge from leaving a space when there is no data.
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! Use an IF condition as documented on this page: http://word.mvps.org/FAQs/MailMerge/MMergeIfFields.htm > 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! Thanks Fred. A bit above my head but I will work on it. > Use an IF condition as documented on this page: > [quoted text clipped - 5 lines] > > name when there is no middle initial when running name tags, etc... > > Thanks! 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}  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > 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! 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. > Avoid using the AddressBlock field and use the individual fields of the data > file eg [quoted text clipped - 7 lines] > > between a first and last name when there is no middle initial when > > running name tags, etc... Thanks! 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. SignatureHope 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 > Graham-I do use the individual fields, I.e. FName, MName, LName, etc...I > keep [quoted text clipped - 16 lines] >> > between a first and last name when there is no middle initial when >> > running name tags, etc... Thanks! 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 > Graham-I do use the individual fields, I.e. FName, MName, LName, etc...I > keep [quoted text clipped - 16 lines] >> > between a first and last name when there is no middle initial when >> > running name tags, etc... Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.