Eliminating blank lines in merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lin - 12 Dec 2006 04:08 GMT

Using Word XP for document and Excel XP for data. Some cells in Excel are
blank. During the merge, the blank cells result in a blank line. How can I
eliminate the blank lines.

Reply to this Message

Doug Robbins - Word MVP - 12 Dec 2006 04:31 GMT

Use and If...then...Else field that test for data in the field. For the
result of the true condition, have it insert that field and a carriage
return and then the next field; for the result of the negative condition,
have it insert just the next field

{ IF { MERGEFIELD fieldthatmightbeblank } <> "" "{ MERGEFIELD
fieldthatmightbeblank }[CarriageRetrun]
{ MERGEFIELD nextfield }" "{ MERGEFIELD nextfield }" }

You must use Ctrl+F9 to insert each pair of field delimiters. In place of
[CarriageReturn] press Enter (or Shift+Enter)

Use Alt+F9 to toggle off the display of the field codes.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Using Word XP for document and Excel XP for data. Some cells in Excel are
> blank. During the merge, the blank cells result in a blank line. How can I
> eliminate the blank lines.

Reply to this Message