Send Mail script command over multiple records?

[Hoggy]

Hi everyone,

Looking for a bit of advice on using a script to send emails. I'm using Filemaker Pro v8. The application itself is fairly simple, just a database of bookings for a band. What I want to be able to do is send a quick email listing all upcoming engagements to players. (So they don't have an excuse for forgetting about them!)

Each engagement is its own record, and somewhat annoyingly the "send email" script command only sends information from one record. What I'm wanting is information from all the records in the found set.

I've defined a text calculation field, the end product of which is a summary of all the vital details for each engagement. (Where it is, when to turn up etc.) So even if I can put just this one field in the email that would be all I'd need, but I need to get the info from all the upcoming records.

Can anyone suggest any useful workarounds to get this happening? I know I could write a looping script that sends one email for every record, but I'm hoping that there's a more elegant solution out there.

[Heathbo]

A really simple sollution would be to make a global text field. Then wright a looping script that goes to each record and adds the contents of the current record to the global text field. The loop ends after the last record and then the 1 email with that global field is sent.