 |
 | 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 / April 2005Suppress Lines
How do I suppress lines not being used in an address? Name Organization Address City, ST Zip If there is no organization, I want the lines to move up, not show a blank line. Probably the simplest method is to insert the fields individually and use a conditional field to insert the line feed and the organization field when there is content in it eg {Mergefield Name}{IF {Mergefield Organization} <> "" " {Mergefield Organization}"} {Mergefield Address} etc  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > How do I suppress lines not being used in an address? > [quoted text clipped - 5 lines] > If there is no organization, I want the lines to move up, not show a > blank line. Try Tools > MailMerge > Merge > Select 'Don't print blank lines when fields are empty' Good luck But don't be too surprised when it doesn't work . Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Try > Tools > MailMerge > Merge > Select 'Don't print blank lines when > fields are empty' Good luck Tools > Mail Merge > Suppress blank lines worked in older versions of Word. Word 2003 doesn't have that option anymore - what a pain!! > But don't be too surprised when it doesn't work . > > > Try > > Tools > MailMerge > Merge > Select 'Don't print blank lines when > > fields are empty' Good luck Word 2003 still suppresses blank lines by default, but a. not if the merge fields nested inside another field such as { IF } or { INCLUDETEXT } - a significant and irritating change, and of course when something like that has changed, it's difficult to know exactly what /has/changed, which I suspect is the point of Graham's remark. b. the option to switch the facility off (and on again) in no longer part of the standard user interface. You can can back the old interface by dragging Tools|Customize|"category All Commands"|MailMergeHelper to a toolbar, or you can use a macro such as Sub SuppressBlankLines() ' switch on blank line suppression ActiveDocument.MailMerge.SuppressBlankLines := True End Sub c. the circumstances in which Word suppresses blank lines has always been rather odd. It doesn't suppress any old blank line - it only suppresses lines that are blank because they are blank, /and/ they have a non-nested MERGEFIELD field whose result is blank. Blankness created in other ways isn't enough :-) Actually my memory on this one is slipping, but that's the gist of it. Peter Jamieson > Tools > Mail Merge > Suppress blank lines worked in older versions of > Word. [quoted text clipped - 5 lines] >> > Tools > MailMerge > Merge > Select 'Don't print blank lines when >> > fields are empty' Good luck |
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.