I'm merging address fields from an Excel 2007 spreadsheet to create labels in
Word 2007. Not all of the labels use all of the address fields, so a blank
line on the resultant address label often occurs. How can I eliminate these
blank lines? I seem to recall that in earlier versions of Excel and/or Word
this either happened automatically or there was a prompt asking if blank
fields should be ignored.