This makes sure the field is not Empty if it is empty then it would return 1 for true.
My email script is sending out a bulk email, thought it is one specific email per record. I think I need the script to Find Only the records that contain an email address and send to only those records. I think what you were suggesting would be if the script was only sending one email.
I assume you had a script with a loop then you would use a if statement. Yes, you could use a find and omit the records that don't have a email address. I have to assume some things when I haven't seen the app or script the person is referring to. Sometime there are better answer. I try to answer as fast as I can and go with the first idea I come up with, which is not always the best answer. I try to help. The Find Omit method is more likely the best way to go.
Can you show me what a script would like that does this?
Find All records that do not have email addresses and Omit them;
Find All records that do have email addresses and send them the message;
Show All records again after the mail has been sent.
Thanks - Charlie
The Secret Life of Find Mode: Omit
Finding Records With Empty Values In A Field
Answer ID: 1466 Last Updated: Oct 31, 2007
ISSUE: How do I find records within my database that have no values entered in a specific field?RESOLUTION:
There are several ways to do this, by entering find mode and using the symbols that are available in the status area, or by simply typing any of the following symbols in the specific field:
"" (also check the Omit checkbox in the status area)
These symbols instruct FileMaker Pro to find emptyfields.