Sent mail status

[rudym88]

Hi all,

I have a script that will send an record via email. I also create a table where a record is added every time an email is sent.

On the second table I have a "result" field where I would like to enter either "successful" or "unsuccessful". Does anyone know how do this when using "send mail".

Thanks

RudyM

[Chris Cain]

Use get ( lasterror )

[Matt Leach]

My database has a similar function. I have a field for result, script looks something like this:

SetError Capture [On]

perform sending of email

If [Get( LastError ) = 0]

Set Field [resultfield; "Successful"]

Else

Set Field [resultfield; "Unsuccessful"]

End If

Commit Records/Requests

Edited September 17, 2010 by Guest