How do I avoid () in my WORD Mail Merge document

[Wickliffe]

How do I avoid the resulting () in my WORD Mail Merge document when the Excel
data field is blank?

 

[Doug Robbins]

Add a formatting switch to the mergefield

\# "0;(0);"

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

 

[Graham Mayor]

I take it the brackets are inserted as part of the document text - in which
case place them (and the field) with a conditional field eg

{IF {Mergefield fieldname} <> "" "({Mergefield fieldname})"}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>