Is it possible to send an auto email to a person as per the target date in a datagrid column of Flash CS4 (AS 3.0)?
I have the following example file attached herewith.
It should check the target date column and if the target date is equal to current date then it should send an auto e-mail to the respective person using the E-Mail ID from the datagrid.
For example (as per attached list):
An email to be sent to Mr. Rangarajan on 15-APR-12 with subject "Submission of BCM Procedure draft" using his email id from the "E-Mail" column of the grid i.e. firstname.lastname@example.org
Please let me know whether it is possible?
You can probably do it, though Flash won't be able to send anything. Flash could only go as far as opening the user's email client with some information already filled in. It couldn't execute sending that email. What you will need to do is have a server-side script (such as a PHP script) that Flash sends the data to that prepares and sends the email.
You probably also want to have something that prohibits sending more than once, such as removal of the data from wherever Flash gets it or a change in status that Flash uses or some email logging system that the PHP file checks against.
Just an aside comment: the email would only be sent if somebody actually views the flash file on the target date....
So if your server supports cron or some other way of scheduled execution, a server script should probably read the data source and handle the mail sending
Europe, Middle East and Africa