Mail merge problem

[pcor]

I am mail merging from an excel 2007 file. I am mail merging a colum header
call TOTAL
TOTAL does NOt have data in all the rows.
When TOTAL has data I want to show that data but when the cell is blank I
want to show $0.00
How can that be done?I am currently using {mergefield Total \# "$0.00"}
Thanks

 

[Graham Mayor]

You will probably need a conditional field

{ IF { MERGEFIELD Total } <> "" "{ MERGEFIELD Total \# "$,0.00" }" "$0.00" }

see also http://www.gmayor.com/formatting_word_fields.htm
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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