Email Template IIF(Len) command

[yframediscounts]

Hi

In the Email Template I am trying to put the words "Sent by Yodel Tracked" if the ORDER.POSTALTRACKINGNUMBER has a tracking number in the field

I am try to use



EVAL{BEGIN}

<IIF[Len[{ORDER.POSTALTRACKINGNUMBER}]>0,"Sent by Yodel Tracked.",""]>

{END}

But the return error is

EVAL ERROR: Failed to evaluate the rule expression: The left operand token is null: There may be an issue with the rule syntax.

Can anyone Help

Regards

Paul

[NTC]

are we sure we are talking about an Access database? I myself do not know what is meant by the 'email template'; but in any case Access syntax is:

IIF(Len[ORDER].[POSTALTRACKINGNUMBER]>0,"Sent by Yodel Tracked.","")

of course if it is truly a number then you don't have to use length but rather just >0