I'm trying to create an event that will automatically send an email to whomever I have assigned a lead to, once the record is added. This will alert them so they will know to log on because they have a new lead. I found the topic "Send an email to selected users" in the PHP Runner 6.1 manual. Neither of the two options will work, because one of the options only allows the subject and text areas to be hard coded, Plus you have to make a button. The other will not work, because the user has to type in the email address,the subject,etc.
What I want is after a new customer (lead) is added, I want a notification email sent automatically, I.E. no additional button to push. It will need to be able to send to selected users. The data that would be being sent is the record that was added. The only options I have seen in the Events page is "Send a simple email" and "send email with new data" the problem with those options is that the email address must be hard coded. There are to tables also one "CUSTOMERS", which is the table that the record is being added to. And there is also "ASSOCIATES" the table that contains the email address.
Is there a way to have everything dynamic and nothing static (the subject would be ok to have static)?
Please help if you have any ideas, I'm sure its not too hard.
Thank you Bill P.
