Multiple Email Recipients to find multiple contacts

[cvoith]

Hey guys,

I am trying to build an automation that finds a contact's record from an To recipients email address from a Outlook: When a new email is received trigger. This works when there's only 1 recipient, but when there's multiple it isn't able to find the contacts with the associated email address. 

This thread was helpful to pull the first email address from the string when I send the email address to a field and then parse out: https://community.airtable.com/t5/other-questions/extracting-first-email-in-a-field-with-multiple-em...
But my team wants to have all contacts listed on these interactions. 

Does anyone know how to get airtable natively (we can't use zaiper) to search for multiple email addresses from one field?

Thanks!

[Eric_L]

Hi,

This seems easily achievable using a script to parse the data and separate it in multiple emails. However, as the script cannot output, it would likely require a new table to temporarily store the contact addresses, and then a new automation to find the contacts' records.

Does this make sense?