Hi all,

Is it possible to automatically trigger an e-mail from within ERPLn on some database action like inserting a record in item general table (tcibd001).

Please guide. An example if possible would be appreciated.

Vishal

If you are not hung up on 'immediate' email then this could be done through SQL DTS, we do it two times a day all the new items came into the system to group of approvers.

If you are not hung up on 'immediate' email then this could be done through SQL DTS, we do it two times a day all the new items came into the system to group of approvers.

Hi,

I was able to do it through sp_send_dbmail procedure of SQL 2008 in an AFTER INSERT trigger on specific ERPLn table.

Regards,
Vishal