Jump to content

Email script errors

Recommended Posts

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

Link to comment
Share on other sites

I would imagine something like:

Perform Find [ ]
Go to Record/Request/Page [ First ]
Set Error Capture [ On ] 
   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)?


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By mleiser
      I added two container fields in my database. I put a picture in each and set it as global. Worked fine. Went to a second computer and opened the file and they're not there. Closed my file and reopened it and they're not there. I put them in originally with copy paste. Any idea what I'm missing? Thanks.
    • By mleiser
      Here's a strange question. I have a parents table and a student table. I have a field in the student table that creates the student name concatenated with their grade. In the parent table I have a field that puts all the parents children and their grades in one line for a printout. I use the substitute(list(student.... function. Works fine. Is their any way to get different fonts for different students in that line? If a student is in a certain grade I need it to be in a different font within the same line. Each parent's children, some in font a and some in font b depending on the grade. I know it sounds a little crazy, but any ideas? Thanks
    • By cincin
      Where can I find the installer files for the Mac version of FileMaker 18 Server? All that's available on the Claris website now is version 19.
    • By mleiser
      Is there a way to format a number into dollars and cents with dollar sign, not in the layout, but in the database or email message, where I ultimately need it? TIA
    • By mleiser
      I have some graphic pictures on some of my layouts. When you click on them you can resize them. I got a new jpg file and when I want to put it on the layout it says it has to make the page larger but when it inserts it I can't amke it smaller. It's one large picture. How do I make the jpg file smaller to fit properly on a layout? Tha handles just don't come up. TIA.
      I put it on a separste new blank layout and was able to make it smaller. It's a shame you can tell it not to enlarge your layout and just make it smaller the first time. Anyway, I got it. Thanks.
  • Who Viewed the Topic

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.