How can i send automatic mail based on data selection
Hi all,
I need to apply the below logic in the uploaded sample QV.
Based on the column (Remaining time) , if it is less than 2(hr) automatic mail needs to be sent to the team (Group) with the subject as ticket number(Case Id) .
The above logic will be checked based on on open or reload of the application. Please suggest your idea.
Thanks a lot for the logic that you have used. It is exactly the same that i wished as, can you please help me out in one more logic in the application ,
How can i set the mail recipients automatically based on satisfying the above conditions. So that in mail recipient (alert) field it is not necessary to enter all the mail ids.
I know you have a solution to your question, but I would recommend that you look at third party reporting options like NPrinting for this kind of work instead of using alerts. Alerts require the document to be open in desktop or in IE client, which is a 'stop gap' type of approach.. Whereas something like NPrinting can be set to run on a formal scheduled batch process.
You also can have greater flexibility about the information contained in the emails if you dont rely on Alerts' limited options.
