AnsweredAssumed Answered

My table has the following fields: Region, Coordinator, Manager, RecruiterA, RecruiterB,...

Question asked by ErickJ.Gonzalez on Mar 11, 2015
Latest reply on Mar 13, 2015 by philmodjunk

Post

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.

 

Outcomes