 |
 | 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 2005how do I remove excess spacing between data flelds when using wor.
«Sal» «FirstName» «MI» «LastName» «Suffix» I have excess spacing between the middle initial and last name when the person does not have a middle initial. Use an If...Then...Else field that returns the MI and the LastName if the MI exists or just returns the LastName if it does not. { IF { MERGEFIELD "MI" } <> "" { MERGEFIELD "MI"} { MERGEFIELD "LastName" } { MERGEFIELD "LastName" } } Use a non-breaking space between { MERGEFIELD "MI"} and { MERGEFIELD "LastName" } so that it gets treated as the result for the "true" condition.  SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP > ?Sal? ?FirstName? ?MI? ?LastName? ?Suffix? I have excess spacing between > the > middle initial and last name when the person does not have a middle > initial. Doug Given the space is that going to work without the speech marks? { IF { MERGEFIELD MI } <> "" "{ MERGEFIELD MI} { MERGEFIELD LastName }" "{ MERGEFIELD LastName }" } might be better in the circumstances? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Use an If...Then...Else field that returns the MI and the LastName if > the MI exists or just returns the LastName if it does not. [quoted text clipped - 12 lines] >> middle initial and last name when the person does not have a middle >> initial. Thanks, Graham. I thought that the non-breaking space might do the trick, but testing it now, I find that it doesn't. SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP > Doug > [quoted text clipped - 21 lines] >>> middle initial and last name when the person does not have a middle >>> initial.
|
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.