[Linda]

I have an Excell data base that I convert to a Word directory. It has
addresses, phone numbers, comments, etc. When it is converted to a directory
if there is no information in the Excell column then Word puts in a "0". I
want to get rid of that zero. How?

[Doug Robbins - Word MVP]

{ IF { MAILMERGE Nameoffieldthatsometimesreturnszero } = 0 "" "{ MERGEFIELD
Nameoffieldthatsometimesreturnszero }" }

You must use Ctrl + F9 to insert each pair of field delimiters and Alt + F9
to toggle off their display.

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

"Linda" wrote in message
...
I have an Excell data base that I convert to a Word directory. It has
addresses, phone numbers, comments, etc. When it is converted to a
directory
if there is no information in the Excell column then Word puts in a "0".
I
want to get rid of that zero. How?