Syntax Error when executing expression for non-existant data

Hi -
In order to use percentages in my mail merge document, I had to add an expression statement similar to {=(MEERGEFIELD "whatever"}*100\# "0.00%"}. In this situation, if the mergefield is not filled, a syntax error is posted. Is there a way that I can test for the existance of data prior to executing the statement?

Thanks!
Lily

Try something like

{ IF "{ MERGEFIELD "whatever" }" = ""
"result you want for null"
"{ ={ MERGEFIELD "whatever"}*100 \# "0.00%" }" }



--
Peter Jamieson

"Lily" wrote in message
...
Hi -
In order to use percentages in my mail merge document, I had to add an
expression statement similar to {=(MEERGEFIELD "whatever"}*100\# "0.00%"}.
In this situation, if the mergefield is not filled, a syntax error is
posted. Is there a way that I can test for the existance of data prior to
executing the statement?

Thanks!
Lily