Before you run the script, put the field on the layout to see if there is a value in it for that particular record.
I'd take a careful look at the exact content of your approve field.
In your script it has to exactly contain "yes" (without the quotes and it's not case sensitive.) If there is an extra character such as a space or a carriage return in that field, then your email will not be sent.
If your field is formatted with check boxes or radio buttons, you may need to temporarily remove the value list format so that you can directly inspect the field. You may also have to click in the field to see there are spaces and/or a carriage return character messing up your script.
Thanks for the post got it to work!!
I want to send an email based on the IF condition inside Go to Record. For example, I write like below.
IF (EMPDET::result_z = 0)
But when I write this IF condition in script, it goes to Calculation page. There it did not allow me to finish the IF condition as It says parameters missing. I think it expect the syntax.... but I need this send mail only when condition, EMPDET::result_z = 0. If its 1, then no mail.
How can I solve this issue?