[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
Word MVP web site http://word.mvps.org





pcor wrote:
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