weekly reminders only for people who opted in

Hey ​@sarahschoon,

It sounds like the issue might be in the Second Action.

Instead of using the repeating group with the send email action inside, you can remove the repeating group and just use the send email action. In the “To” field you would still use “list of email”

​@BuildForAT, that does seem like it would work better, but all four of us are still automatically being CC’d to the reminders.  (screen shot of preview included in case it’s helpful). When I go to the CC field, nothing is there, so I can’t remove anything.

Great! We’re making progress.

If you want to eliminate the CC list, we’ll do something else instead. We’ll go back to having that repeating group with the send email action.
But now, in the “To” field, we’ll put in “Current Item” and select their email:
 

This should send a separate email to each member.

Let me know if that gets you what you want.

This happens because when you use "Find records" and then send an email to the whole list, Airtable ends up sending multiple emails to each person.

To fix it, use the “Repeat for each record” step, and in the email action, make sure the “To” field pulls the email from the current record, not the full list. Each member row should have just one email linked to it, so this way each person only gets one email.

Double-check that CC and BCC are empty too, just in case.

Taha, Airtable Advisor

re: all four of us are still automatically being CC’d to the reminders.  (screen shot of preview included in case it’s helpful). When I go to the CC field, nothing is there, so I can’t remove anything.

Ah this is expected actually.  Assuming you have 2 addresses in the ‘To’ input, e.g. jerry@test.com and george@test.com

Then when Jerry opens their email, this is what they’d see
 

And this what George would see:

Assuming your automation’s set up like this, then that’s going to be sending out one email to every email you’ve found and you won’t need to worry about the CC field:

If you don’t want them to be able to see who else is getting the emails, then BuildForAT’s solution will get you sorted

​@BuildForAT and ​@Taha-Jiruwala thanks for your help! This seemed like it would work, but a new problem has come up: it now is only identifying the top person on the list (which currently has four names/emails). So it isn’t CCing anyone, but it isn’t recognizing anyone else on the list, either.

This is what my “To” field token looks like:

And then this is what options I have in the generated preview:

Thoughts? I feel like there’s something very obvious I’m doing wrong but I can’t for the life of me figure out what.

That looks fine; you’re using the output within a Repeated Group action so seeing one email only is expected.  Try running the automation by triggering it (not testing it) and you’ll see that it sends one email per found record

​@TheTimeSavingCo as I said from the beginning, it is actually sending multiple emails to each person every time, not just showing it in the preview but when I run the test. What you showed above makes sense in theory, but is not what’s happening in real time on my end...which is why I am trying to crowd source.

The images you shared look correct to me, but if it’s not working on your end, I’ll need more information to help.

If possible, please share a read-only link to your Airtable base. That way, I can take a closer look at your setup and figure out what might be going wrong. From the screenshot alone, everything appears to be set up properly.

Taha, Airtable Advisor

Hmm, yeah, I think I don’t understand something about your setup, hopefully one of the other can help you solve your issue.  As a reference, I’ve set up an automation here that has an automation that:

1. Has a ‘Find record’ step that looks for every record that has an ‘Email’ value
2. A repeating group that uses the results of that Find Record step
3. Sends one email to each person only

Here’s the base data 

And here’s what the automation sent out:

Best of luck!

​@BuildForAT and ​@Taha-Jiruwala , thanks again to you both--I forgot to come back and update, but I was able to get the automation to work! I don’t know why BuildForAT’s solution wasn’t working the first time (token being “current item” → “Value from Field” → “Email”), but when I deleted the automation and started over, it worked fine. I know my original setup was wrong, and now I know that this one works...so thanks to y’all for troubleshooting!

​@sarahschoon Thank you for the update! Glad we could help!