2. ASPRunnerPro General questions
  3. send an E-Mail after record update
This topic is locked

send an E-Mail after record update

 		12/24/2011 8:44:14 AM
ASPRunnerPro General questions
M
 mr. zx author

Hi All,
How can i send e-mail after record update just to user entered this record.
thanks for all
regards,
Sergey Kornilov admin 12/26/2011

In AfterAdd event you can use values("FieldName") to access any form field value.

set params = CreateObject("Scripting.Dictionary")

params("to")=values("EmailField")

params("subject")="Sample subject"

params("body")="message"

runner_mail(params)


Replace EmailField in example above with field name that stores email address.
M
 		mr. zx author 12/27/2011



In AfterAdd event you can use values("FieldName") to access any form field value.

set params = CreateObject("Scripting.Dictionary")

params("to")=values("EmailField")

params("subject")="Sample subject"

params("body")="message"

runner_mail(params)


Replace EmailField in example above with field name that stores email address.


Thank you for your response, but this solution if the email field in the same table What about if the email field in another table.
Regards,
Sergey Kornilov admin 12/27/2011

In this case you need to execute an additional SQL Query to retrieve email address from another table.
You can use DAL for this purpose, see examples at http://xlinesoft.com/asprunnerpro/docs/query.htm
M
 		mr. zx author 12/31/2011



In this case you need to execute an additional SQL Query to retrieve email address from another table.
You can use DAL for this purpose, see examples at http://xlinesoft.com/asprunnerpro/docs/query.htm


Thanks admin & I will try
regards,