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

W

Wickliffe

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

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
 
G

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Top