 |
 | 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 / July 2004If-fields in a bulleted list in a Word mail-merge document
I have a bulleted list of 6 items which depend on fields being blank or not blank in an Excel spreadsheet. The If- statements work, however, the word document displays blank lines with bullets. How can I tell word not to print the blank lines. With thanks for your help. Regards Helga Jewell Include the line feed in the conditional result so that it is only present when the condition is true. eg {IF {Mergefield FieldName1} <> "" " Do this"}{IF {Mergefield FieldName2} <> "" " Do this"}etc  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I have a bulleted list of 6 items which depend on fields > being blank or not blank in an Excel spreadsheet. The If- [quoted text clipped - 5 lines] > Regards > Helga Jewell Dear Graham Thank you very much for your advice, however, I still can't get it to work. Is there a possibility of sending you the document and attached spreadsheet sample? In your example, what represents the line feed? Regards Helga >-----Original Message----- >Include the line feed in the conditional result so that it is only present [quoted text clipped - 15 lines] > >. I am away from my office until the end of next week so I cannot accept documents at present. Obviously you need to change the field names to those in your data file and the curly brackets are inserted with CTRL+F9. The line feed is inserted by pressing the enter key at the required places. Does that make it any clearer? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Dear Graham > Thank you very much for your advice, however, I still [quoted text clipped - 32 lines] >> >> .
|
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.