"0" in empty column when converting from Excell data to Word direc

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Linda - 15 Mar 2007 23:32 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 16 Mar 2007 00:58 GMT

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

Signature

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

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

Reply to this Message

Rate this thread: