One Email per Record - Monthly Automation

[LeighAnnMoltz]

I see several posts that are similar to my question, but I haven't been able to find the actual solution yet.  

I have a database of all our locations, and at any given time we have about 40 pending locations. I'd like to send an automated email to the listed manager each month asking for an update until the status is changed from pending to open.  

Some managers have multiple pending locations at one time so I'd like to only send one email per manager rather than multiple if there are several pending in their area. There's probably a few ways to do this, but for now I have a rollup column on a different table that breaks down by district all the pending locations.

Any thoughts?

[kuovonne · Accepted solution]

Do you have a table of managers that is linked to their locations? If not, make one. Include a conditional rollup field that says if any of the manager's locations are pending.

In your scheduled automation, have a "Find Record" for each manager that has a pending location (based on the rollup field). Then have a repeating group based on the found records. Inside the repeating group, Use the "send email" action inside the repeating group.

[LeighAnnMoltz]

I do have that rollup set already. I think I set this up the way you recommended. 

My concern is that it looks like it's sending to the "group" and not per individual. 

How do I fix that? 

[kuovonne]

When configuring the “to” email address from the current list item, not the “Find records” result. 

[LeighAnnMoltz]

Oh my gosh ..... so obvious. Thank you!!!