Sending multiple email messages
You can use FileMaker Pro to send multiple email messages to one or more recipients. To specify email addresses, subjects, and messages, you can type text, use data from each record in the current found set, or use calculations. A separate email is sent for each record in the found set.
To send multiple email messages:
1.
See Finding records.
2.
Choose File menu > Send > Mail.
The Send Mail dialog box appears.
3.
For Send via, choose how you want to send the email.
 •
 •
To send using SMTP (without an email application), choose SMTP Server. In the SMTP Options dialog box, enter user and server information (see Entering or editing SMTP options) and click OK. Then continue with step 4.
4.
For Create, select Multiple emails (one for each record in found set).
5.
 
Click Arrow button and choose Specify Field Name. Then select a field and click OK.
Click Arrow button and choose Specify Calculation. Then create a calculation and click OK.
Click Arrow button and choose Specify Email Addresses. Then choose the email addresses you want.
6.
If you specified a field or calculation in step 5, select Collect addresses across found set if you want to gather addresses from all the records in the current found set for each message.
Important  Use Collect addresses across found set with caution because it can generate a lot of email messages. For example, if your found set contains 10 records and you specified a field that contains a single email address in each record, 100 email messages would be generated. Each email address will receive 10 emails. See the example below.
7.
Do one of the following to fill in the Subject and Message boxes:
 
Click Arrow button and choose Specify Field Name. Then select a field and click OK.
Click Arrow button and choose Specify Calculation. Then create a calculation and click OK.
Click Arrow button next to the Message box and choose Insert Text from File. Then choose the text file you want.
8.
Select Attach file if you want to select a file to send as an attachment to the email.
9.
Generated email messages are sent using your default email method.
Notes
 •
 •
Example
When you specify a field or a calculation as the email address, the number of messages sent depends on the contents of the fields or the result of the calculation and whether you select the Collect addresses across found set option. Suppose you have the following found set:
 
When you specify the Address field for the email address and select Multiple emails (one for each record in found set), each message is addressed to only one recipient and the results are:
 •
 •
 •
If you select the Collect addresses across found set option, all three recipients receive all four messages (Subject1, Message1; Subject2, Message2; Subject3, Message3; and Subject4, Message4) and each message is addressed to all three recipients.