AnsweredAssumed Answered

Email Script with Certain Criteria

Question asked by jehjeh on Oct 14, 2016
Latest reply on Oct 18, 2016 by jehjeh

I have created a script to send email and omit records that DO NOT have an email address in the email address field. The following script works exactly as it's supposed to.


Go to Record/Request/Page [First]


   If [IsEmpty (Producer Database::Current Email Address)]

      Omit Record


      Go to Record/Request/Page [Next; Exit after last]

   End If

End Loop

Send Mail [BCC: Producer Database::Current Email Address; Subject: "My Subject line here"]


What I am trying to incorporate into that same script is the command to tell it to also look at a field that contains the word "Inactive" and to look at a "Check Box" field in order to omit those records as well.  The "Inactive" field will only have that one word in it. So if that field is empty then it should be allowed to use that record to send email. The "Check Box" field should only omit if the check box IS checked. I would like my final result be that if any or all of the three fields meet the criteria, (i.e. empty email address field, filled Inactive field or a check box that is checked), then that record will be omitted from sending an email to that recipient.


I am using FileMaker 7.  That is not going to change anytime soon.


Your help is greatly appreciated