Click here to Skip to main content
15,889,216 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I am developing a HRMS application where i need to send alert mail to employees one week before of their visa expiry. Please help how i will able to do that.
Posted
Comments
Richard MacCutchan 17-Apr-15 8:35am    
Check the expiry date on their card, and if it is within a week send the email. Exactly what part of this do you not understand?
Aone starteam 18-Apr-15 3:43am    
How there will automated expiry date check and after that mail will send. Please share any article regarding this concept
Richard MacCutchan 18-Apr-15 3:46am    
Are you saying that you do not know how to get the difference between two dates and compare against some other value?

1 solution

Check this one...just change the issue and checking date....and your work is done..
http://www.aspsnippets.com/Articles/Automated-Email-Notifications-using-SQL-Server-Job-Schedular.aspx[^]
 
Share this answer
 
Comments
Aone starteam 17-Apr-15 9:33am    
Thanks for reply but i need for my website because hrm will be online not on local server.
Arkadeep De 18-Apr-15 3:53am    
implement it in your server...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900