Mail Merge Percentage some formatting correct some not

[kimhr]

I'm mail merging from excel to word and my percentages are sometimes turning
out correct...if there was a value in the excel spreadsheet. For those
fields that did not have a value in it, I'm receiving a syntax error.

I'm using this formula to get this far:
{ ={ MERGEFIELD percent }*100 \#0% }

Help???

 

[Doug Robbins - Word MVP]

Try

{ IF { MERGEFIELD percent } <> "" { = { MERGEFIELD percent } * 100 \# 0% }
"" }

That would return nothing if there is no value in the field. If you wanted
0% to appear in the case of an empty percent field, then insert a 0% in
place of the "" before the final field delimiter.

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