Syntax Error when executing expression for non-existant data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lily - 12 May 2004 18:16 GMT

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

Reply to this Message

Peter Jamieson - 12 May 2004 21:26 GMT

Try something like

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

Signature

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?

> Thanks!
> Lily

Reply to this Message