My table has the following fields:
Region, Coordinator, Manager, RecruiterA, RecruiterB, RecruiterC and RecruiterD
I have two buttons in my database, that when I change the status of a family in my database I click:
Button 1 - and an email with a pdf attachment of the record is sent to "Sarah (coordinator)" and cc's "Michael (supervisor)", "RecruiterA" and "RecruiterB" in Region1
or if I click:
Button 2 - an email with a pdf attachment of the record is sent to "Melissa (coordinator)" and cc's "Maria (supervisor)", "RecruiterC" and "RecruiterD" in Region2
So here is my issue:
Ideally I would press one button to generate an email to the corresponding individuals. Each family has a corresponding recruiter and I would like to have the email go to the corresponding recruiter and not both recruiters in the region.
As it stands right now I click the button and have the script set up to show the dialog box, where I then manually remove the email of the Recruiter that should NOT receive the email.