You can use Send Mail in a script to send the email. The same script can use set field to modify a field in a record to document the fact that an email was sent.
hmmm. i tried that using the "insert text" command under the Fields subheading for the script actions. I just selected the field name, then in specify, entered in the text i want, simply "yes."
i ran it a couple of times as test and on one occassion it marked only one record, on the other occassion it marked no records.
must be missing something. or maybe i am using the wrong action in the script menu. I'm in FMP11 by the way.
Set field is a better option than insert text--which can fail if the referenced field is not present on the current layout at the moment it is excecuted.
It would change the value for only one record. Why would it need to change the value of a field for more than one?
If you are emailing a single email to a group of different recipients, you may need to use set field in a loop or use Replace Field contents to modify a field's value in all the records in the found set.
ah yes, i maybe didn't mention that it was for multiple records. The function i am trying to achieve is sending a single email to a set of found records, and marking each of those records in a field that indicates an email was sent to them.
I'll try these selections and see what i can sort out.
perfect! got it. and now i'm going to work on setting some merge fields into the email test to customize each email, so back with some more questions on that one after i tinker aroud some.