Mail Merge Percentage some formatting correct some not

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kimhr - 27 Jul 2008 18:55 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 27 Jul 2008 20:15 GMT

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.

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

> I'm mail merging from excel to word and my percentages are sometimes
> turning
[quoted text clipped - 5 lines]
>
> Help???

Reply to this Message