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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wickliffe - 11 Aug 2005 22:41 GMT

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

Reply to this Message

Doug Robbins - 12 Aug 2005 05:17 GMT

Add a formatting switch to the mergefield

\# "0;(0);"

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

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

Reply to this Message

Graham Mayor - 12 Aug 2005 05:55 GMT

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})"}

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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

Reply to this Message