Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Emailing Multiple Records

Featured Replies

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!

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.

  • Author

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!

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.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.