Skip to main content

Send email to collected records action

Send an email to many records at once from an automation, for example a renewal reminder to every tenant whose lease ends this month, each by name.

Written by Leo

Send email to collected is an action that sends one email for each record in a list of collected records. In the action list, its description reads Send an email to all collected records. It's meant to help you reach many people at once, without writing each email by hand or building a loop.

You can use this action for many things, including:

  • Reminding every tenant whose lease ends this month to confirm their renewal.

  • Sending each candidate in a recruiting pipeline a short status update.

The action Send an email to all collected records in Expenses with To, Subject, Show more, the Message box, and Show preview

Note:

  • A manual run sends real emails. Test with a collection that has only your own address in it.

  • Emails count toward a daily quota. Emails sent through Tape's account count toward your organization's 24-hour sending quota. Once it's used up, further emails aren't sent, and the step fails.

  • Each collecting action returns up to 1,000 records. If more records match, the result is cut to the first 1,000 without a warning. For very large lists, send in batches. Learn more about sending bulk emails in batches →

Who can use the Send email to collected action?

  • Automations are available on the Free, Plus, and Premium plans. The number of automation actions per month depends on your plan. See the limits for your plan on our pricing page.

  • To add or change this action, you need to be a workspace admin of the workspace the app is in. You also need full access to every app the automation uses.

  • Any member of your organization can add an email account. Guests can't.

Add the Send email to collected action

To send an email to every collected record:

  1. Open the app and click the automations icon at the top right (Create and view automations).

  2. Open an automation, or select New automation and choose a trigger.

  3. Add an action that collects records, for example Add action → Search for records.

  4. Select Add action → Send email to collected. The step appears as Send an email to all collected records.

  5. Next to in, check the collection. Tape preselects the nearest collection above this action. To change it, select its name. Without a collection, it reads Select collected records.

  6. Fill in To and Subject.

  7. Write your message in the text box below Subject. Select Show preview to check it.

  8. Select Show more if you need CC, BCC, a sender name, a reply-to address, or attachments.

  9. Select Save changes. For a new automation, the button reads Create automation.

Below Search for records in Expenses, selecting Add action and Send email to collected, so the step Send an email to all collected records in Expenses appears with To, Subject, Show more, and the Message box

Send email to collected settings

Send an email to all collected records in Expenses with all options open: To, Cc, Bcc, Account set to Tape, From name, Reply to, Subject, Attach file, Show less, the Message box, and Show preview

Without Show more, you'll see Select collected records, To, Subject, and the message box. With Show more, the settings appear in this order:

  • Select collected records: the collection to send to. The list shows the collections created by actions above this one. One email goes out per record in the collection.

  • To: who receives each email. Enter an address (the placeholder reads Type '@' for variables), or insert an email or person field of the collected records. To do that, type @ in To and select the field under Collected / <record name>.

  • Cc and Bcc: more recipients, visible or hidden.

  • Account: the email account the message is sent from. Unless your organization set another account as default, this is Tape's sending account, shown as Tape. The menu lists the accounts, marks the default one with Default, and ends with Add account. To send from your own account, open the menu under Account and select Add account.

  • From name: the sender name recipients see, for example your company name.

  • From address: the sender address. It appears only when you choose your own email account under Account.

  • Reply to: where replies go, for example [email protected].

  • Subject: the subject line. You can mix text with record values.

  • Attach file: attach files from a file field of the records. Open Select a field and select the file field, then select which files to attach:

  • All files will attach every file in the field.

  • Filtered files will attach only files that match a condition.

  • Most recent file will attach the newest file.

  • Most recent file filtered will attach the newest file that matches a condition.

  • The message box: the body of the email. It has a toolbar with File, Edit, View, Insert, Format, and Table menus, so you can format text and insert record values. If you leave it empty, the email is sent without a body.

Under Show preview, you can check the email before you save:

  • Show preview opens the preview. Its tooltip reads Show preview and simulate variables (option/alt + P).

  • Simulate variables fills the record values with sample values, so you can see how a finished email looks.

  • Exit preview goes back to editing.

  • Open preview in new tab (cmd/ctrl + shift + P) and Open in fullscreen (cmd/ctrl + enter) show the preview in a bigger view.

Record values in emails

You can insert fields into To, Subject, and the message. When the automation runs, Tape sends one email per collected record and replaces each tag with the value from that record. In the editor, the tags look like @Tenant / Name. Insert fields of the collected records from the group Collected / <record name>. Fields of the record that started the automation stay available in their own group.

  • An email or person field in To sends each email to that record's address.

  • A person field in the message can insert the person's name, for example "Hi Juliet,".

  • Record URL inserts a link to the record, so the recipient can open it directly. Use Record URL from Collected / <record name> to link each email to its own record.

Let's look at an example

Let's say your property management team wants every tenant with an expiring lease to get a renewal reminder. Here's how:

  1. Set the trigger to When a record is updated in a "Notices" database app and select the field Send reminders.

  2. Add the filter Where Send reminders Has changed to "Send".

  3. Select Add action → Search for records, select the app Tenants, and add a filter so only tenants with the lease status "Expiring" are collected.

  4. Select Add action → Send email to collected and select the collection from step 3.

  5. In To, insert the Email field of the tenant. In Subject, enter "Your lease ends soon".

  6. In the message, enter "Hi ", insert the tenant's name, then add a short note and Record URL.

  7. Select Save changes.

The next time a notice is set to "Send", every tenant with an expiring lease gets their own email, for example "Your lease ends soon" with their own name in the greeting.

Send email to collected errors

  • If the step fails, the run shows the step and its message in the automation's runs. Open the automation and select ▷ next to Manual run (View all runs, cmd/ctrl + 1). Each run shows its status, for example Success; select a run to see every step. For all automations, open Runs in the Automation Center and filter by App, Automation, or Status.

  • If Select collected records shows No results, add a collecting action above this one.

  • If To is empty, the action is skipped and no emails are sent.

  • If an email didn't arrive but the step succeeded, check the recipient's spam folder.

  • If your organization's daily quota was used up, the step fails and the remaining emails aren't sent. Try again later.

  • Tape sends the emails one after another. If one email can't be sent, the step stops, and the rest isn't sent. To skip records without an address, add Filter collected first.

Test, pause, or edit the Send email to collected action

  • Manual run runs the automation once. It appears after the automation is saved. Under Run on, select the records, then select Start run (Save and start run if you have unsaved changes). Emails go to the real recipients.

  • New automations you create in the editor are Active right away. The status, Active or Paused, sits below the automation's name in the editor. To pause one, select the status to switch it to Paused, then select Save changes.

  • To change the email, open the automation, select the Send an email to all collected records step, make your changes, then select Save changes.

Learn more

FAQs

What's the difference between Send an email and Send email to collected?

Send an email sends one email, usually about the record that started the automation. Send email to collected sends one email for every record in a collection. Learn more about Send an email →

Can I send the same email to a list of people in one message?

Not with this action. It sends a separate email per record, so each person only sees their own address. To email several people at once in one message, use Send an email with Cc.

How many emails can I send at once?

One email goes out per record in the list, and a collecting action returns up to 1,000 records. Emails sent through Tape's account also count toward your organization's shared 24-hour quota. For large lists, send in batches. Learn more about sending bulk emails in batches →

Why didn't my emails arrive?

If your emails didn't arrive, it could be because:

  • The step failed. Open the automation, select ▷ next to Manual run, and check the step.

  • The emails landed in spam. Ask the recipient to check their spam folder.

  • Your organization's daily email quota was used up. Emails over the quota aren't sent, and the step fails. Try again later.

Can I send from my own address?

Yes, if your organization has connected its own email account. Select it under Account, then set From name and From address. Learn more about connecting your email account →

Can I send only to some of the collected records?

Yes! Use Filter collected before Send email to collected to keep only the records that match a condition. Learn more about filtering collected records →

Are there other actions I can use?

Yes! Actions can create and update records, add comments, send emails, create PDFs, call other services, and more. See every action in Automation actions →

Are you a developer using the Tape API for automations?

The automation API has its own documentation for developers. Full reference: collected_records_send_email in the developer docs →

Still have questions? Find answers and get help from community experts in the Tape community →

Did this answer your question?