How to retrieve email addresses from another Excel Sheet

Help Robot
, , ,
1

Hi everyone, have some issues trying to figure out what to do.

I am currently trying to send reminder emails to various people.

In Sheet 1 (attached), I am trying to send a reminder email to a group if the date of the event has exceeded 30 days. I will need to extract the title of the event from the excel sheet into the email. An email should also not be sent if returns have been received already or a reminder email has already been sent.

In Sheet 2 (attached), the group and the email addresses are listed. I am not sure how to match the “Groups” in both sheets in order to retrieve the 2 email addresses in Sheet 2 in order to insert them into an email.

2

Sheet 1.xlsx (9.9 KB)
Sheet 2.xlsx (9.1 KB)

For reference, thanks!