I am running a SQL query pulling data into labels. I have text headers for
each mailmerge field that is printing. When I run out of data and there are
more labels left on the page the headers print waisting the labels.

How do I turn off or hide the headers for those remaining labels?

You could try putting the headers inside an IF field that tests whether
there is any data to be printed in the address. e.g. if the field "street"
/always/ contains data, use

{ IF "{ MERGEFIELD street }" = "" "" "put whatever text you have in your
headers here" }

where all the {} are the special field codes you can insert using ctrl-F9.

I haven't checked that it works but I'd say it has a reasonable chance of
success.

Peter Jamieson



"Scott Dever" wrote in message
...
I am running a SQL query pulling data into labels. I have text headers for
each mailmerge field that is printing. When I run out of data and there
are
more labels left on the page the headers print waisting the labels.

How do I turn off or hide the headers for those remaining labels?