Syntax Error when executing expression for non-existant data

[Lily]

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

 

[Peter Jamieson]

Try something like

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



--
Peter Jamieson

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?