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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott Dever - 21 Apr 2006 13:54 GMT

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?

Reply to this Message

Peter Jamieson - 22 Apr 2006 10:14 GMT

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

>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?

Reply to this Message