Word 2003 how do I hide text in mailmerge labels w blank record?

[Scott Dever]

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?

 

[Peter Jamieson]

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