View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default "0" in empty column when converting from Excell data to Word direc

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