blank lines in mail merge directory

M

micadoodle

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?
 
G

Graham Mayor

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Auto Merge text from multiple sources 0
Mail Merge Document Type 1
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Conditional Mail Merge won't suppress blank lines 2
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Directory Mail Merge with table layout 2
Mail Merge with Info on different lines. 2

Top