Here is a solution if you have 25 or fewer managers. Basically we will make use of the new Combined Text summary fields to roll up all the manager emails into one field and then parse them out into a semi colon delimited field.
- New table called All managers. Create 1 record. It will be [Record ID#] of 1. Lock down so no one, not even Admins can add another record.
- Make a numeric formula field on the Employees table as a formula value of 1 called [Link to All Managers]
- Make a relationship to All managers based on that field.
- Make a Combined Text summary field where [Manager] = "Y"
- Convert to a formula text field type
var text value = [my combined text summary field];
List(";",
Trim(Part($value,1,";")),
Trim(Part($value,2,";")),
Trim(Part($value,3,";")),
Trim(Part($value,4,";")),
Trim(Part($value,5,";")),
Trim(Part($value,6,";")),
Trim(Part($value,7,";")),
Trim(Part($value,8,";")),
Trim(Part($value,9,";")),
Trim(Part($value,10,";")),
Trim(Part($value,11,";")),
Trim(Part($value,12,";")),
Trim(Part($value,13,";")),
Trim(Part($value,14,";")),
Trim(Part($value,15,";")),
Trim(Part($value,16,";")),
Trim(Part($value,17,";")),
Trim(Part($value,18,";")),
Trim(Part($value,19,";")),
Trim(Part($value,20,";"))
Trim(Part($value,21,";")),
Trim(Part($value,22,";")),
Trim(Part($value,23,";")),
Trim(Part($value,24,";")),
Trim(Part($value,25,";"))
)
use that in your mailto: formula
Put that report (the 1 record report) on your dashboard with just a button to mailto: