Bot, how to send email to multiple addresses

[paula]

Hi all,

I want to send every department heads an email when an employee was separated.

 

But the table whose change would trigger the action, only has the supervisor/manager email. I have a separate table where supervisors'/managers' emails are listed. Therefore, I could not make a TO formula using the heads' emails list cause I'm on another table.

How can I do this? Thank you!

[Suvrutt_Gurjar · Accepted solution]

---

@paula wrote:

only has the supervisor/manager email. I have a separate table where supervisors'/managers' emails are listed.

---

Is there a typo mistake above? Did you actually mean a separate table where department heads emails are listed?

Assuming you meant another table for department heads details, are you able to include an expression something like

Department Head Table Name[Email] 

to include emails of department heads?

[paula]

---

@Suvrutt_Gurjar wrote:

Department Head Table Name[Email]

---

Thanks! I kept doing it like [Heads].[Email]