Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: How to send an email for each record found in Airtable Automations using Outlook

98 0
cancel
Showing results for 
Search instead for 
Did you mean: 
jul14nm0r3n0
4 - Data Explorer
4 - Data Explorer

I am trying to set up an automation that:
1. Runs every Wednesday at 11:15 AM.
2. Find records based on the “Abc” view.
3. If records are found, send one email per record using Outlook.

How do I get one email per record to be sent using Outlook?

2 Replies 2

You would need to use a repeating group to loop through your found records. Then you can send an email to each record in your found set. See this Airtable support article.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Hey @jul14nm0r3n0!

Following with @ScottWorld's answer above, below please find a step by step guide.

1. Create Automation, and set the trigger to be of type "At a scheduled time..."
2. Below your trigger, create a new Action to "Find records". Select your table, and under "Find records based on" select View and your specific corresponding View.
3. Then create a "Repeating Group".

Mike_AutomaticN_1-1739377844097.png

4.  For the Repeating Group's input list, use the output of the Find Record action -see below.

Mike_AutomaticN_2-1739377892871.png

5. For last, create a "Send Outlook" action within your repeating group, and under "To:" field select the email from the "Current Item from list of records".

Mike_AutomaticN_3-1739378010135.png

Below you can find the full automation!

Mike_AutomaticN_0-1739377813313.png

Please let me know if you have any trouble setting that up, and if so feel free to schedule a call using this link.

Mike, Consultant @ Automatic Nation