Script to send email with contents from various fields

[Forum Joe]

Ok, I need to setup a script that will send an email (always to the same person) a list that is generated from my FM Pro database.

So I have it set to do a find matching records, and usually there'll be 10 or so records. I need filemaker to export two fields from each record (Name and Address, for example) and put that list into an email. Can this be done within a filemaker script, or is a more complex applescript required?

I'll also want this script to run automatically at 9:00 on a monday morning.

[bcooney]

Is the final result one email with a list of Names and Addresses?

If so, I'd do a looping script on the found set that builds a global text field and put that global in as the email body, and use Send Mail script step.

There's a plugin that'll allow for scheduled scripting (troi).

[Forum Joe]

Ah of course. Thanks very much.