Use data (email) from table 2 for automations when a new record is entered in table 1.

[Cyprus_Karma]

Hello, this is an airtable newbie question:
I have searched here, watched videos, and am completely failing with the following problem:

I want to create an automation that sends a mail to ALL mail addresses contained in table 2 when a data record is added to table 1.
I have the trigger, it works, it's simple.
In the actions, I only have access to the data of table 1 in the To: field (where the mail addresses should go), not table 2.
How can I access the data of table 2 at this point?

Does anyone have a comprehensible tip for me?
Many thanks in advance for your time
Boris

[TheTimeSavingCo · Accepted solution]

Assuming you want to send one email per email address in Table 2, try setting up your automation like this:

It has a "Find Record" action that'll look for all the records from "Table 2", and you can then use a "Repeating Group" on the results of that "Find Record" action to send one email per found record

[Cyprus_Karma]

Hello Adam,
Thank you very much for your quick reply.
I managed to find the email addresses, but there is something wrong with the formatting?
The test action/preview contains a lot of formatting elements. Is there any way to remove them?
Boris

[TheTimeSavingCo · Accepted solution]

Hmm, feels like you may have selected the wrong data to put into the "To".  Assuming you've set up your data like this:

Try setting up your automation like this:

Link to base

If this doesn't help, if you could you provide a read only invite link to a duplicated copy of your base with no data in it I could set it up for you real quick

[Cyprus_Karma · Accepted solution]

YES YES YES
1001 thanks for the example, that was enlightening. 1 field was wrong
Best regards
Boris