Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
blank lines in mail merge directory
I am merging from Excel into MS Word 2003 to create a directory of employees
and their home/work contact info. Where there is no data in Excel, such as spouse name in the case of an unmarried employee, Word leaves a blank line in the document. How can I avoid this? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
blank lines in mail merge directory
Use conditional fields for the fields that may be blank added to the
previous line eg {Mergefield somefield}{IF{Mergefield Spouse} "" " {Mergefield Spouse}"}{IF{Mergefield Someotherfield} "" " {Mergefield Someotherfield}"}etc Then the line feed and the field are only entered if they have content. Insert the field boundaries with CTRL+F9 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org micadoodle wrote: I am merging from Excel into MS Word 2003 to create a directory of employees and their home/work contact info. Where there is no data in Excel, such as spouse name in the case of an unmarried employee, Word leaves a blank line in the document. How can I avoid this? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word mail merge should suppress blanks left by blank fields. | Mailmerge | |||
How to I get Mail Merge to include Address 3 in a directory? | Mailmerge | |||
Need to Create a Client Directory Mail Merge Document | Mailmerge | |||
How do I not print blank lines in a mail merge document when the . | Mailmerge | |||
How to omit blank lines in mail merge | Microsoft Word Help |