Emailing Multiple Records

[Mariano]

Is there a way in FM7 Pro to right a script that will email all the records with matching data in a field to one email address? Right now I have set up to do one record at a time, but that could be tedious!

[iflurker]

One possibility is to first perform a find by your criteria, then export records to XML with an XSLT stylesheet that converts to HTML on a temporary file on the hard disk, and then attach the HTML to your e-mail without any text in the body. Email clients like Outlook will interpret the HTML attachment as the body of the email. You can do arbitrarily complex processing over sets of data using XSLT --- it's about as powerful as Filemaker layout-based reports.

The hard part in doing this is writing the XSLT stylesheet; I recommend starting with one of the sample stylesheets that come with FMP7 (the "summary report" one is good) and modifying it to suit your needs.

[Mariano]

Thanks for the suggestion.. I did do something with exporting it to a CSV file, then attaching, but I hoped there could be an easier method. OH well!

[Ender]

You could assemble all the record data either using a loop and appending to a global field, or using the Copy All Records script step. Then email that.