[JohnH]

I get to the Don't print ....right from the merge toolbar menu option. From
the Merge option I can select
Merge To - New doc or print
Records to Merge all or range
Radio Button to Don'tPrint/Print blank fields - this is what is not working.
I can alos do queries and such but never use that.

Thanks
John


"lizz1007" wrote:

I am having the same problem. Where did you select "Don't print blank lines
when data fields are empty"? That may work for me.

Here's what didn't work for me, but might for you:

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.



"JohnH" wrote:

Word/Excel 2000
I have a word merge and an excel datafile. Even though I select don't print
blank lines when data fields are empty, the blank field still prints.. The
excel file is a simple table of name, titles, addresses. I tried manually
blanking out fields that had data and they also print when I delete the data.

Thanks
John