I was wondering if the following is possible and, if yes, how to do it.

I have a parent/student database. I created a script where I can send an email with information from the parent record out to the parent. It works fine. I want to set off a script to choose certain records (like those that owe tuition) and send out an email to each of the ones in the found set at one time with what they owe. What I need is to know is which emails couldn't be sent and for what reason (if possible, otherwise just the email) and want the script to continue through till the end without stopping on errors. I tried it once and I got error messages but at one point it stopped sending altogether. If I can do that then I can look at the list of errors as well, I hope. Does this make any sense? Thanks

I would imagine something like:

...
Perform Find [ ]
Go to Record/Request/Page [ First ]
Set Error Capture [ On ] 
Loop
   Send Mail [...]
   If [ Get (LastError) ]
      Set Variable [ $errors; List ( $errors ; YourTable::Email & Char (9) & Get ( LastError ) ) ]
   End If
   Go to Record/Request/Page [ Next; Exit after last ]
End Loop
...

then do something with the $errors variable (show it in a custom dialog or set a field with it)?

 

Thanks!