Automatic Email Notification
-
Dear all, I want to know how to send automatic email notification taking email address from database and send each one ema ;) il according to there status for eg :- Choose email from database of status 1 and send them birthday message and for status 2 membership end message etc and each message template can also be picked by database. As this can be done on regular basis, I know it can be done by window service but how it can be used with c# and sql server 2005 If any one of you have code than Please Post it. Thanks u all for your support RAHUL TANDON
-
Dear all, I want to know how to send automatic email notification taking email address from database and send each one ema ;) il according to there status for eg :- Choose email from database of status 1 and send them birthday message and for status 2 membership end message etc and each message template can also be picked by database. As this can be done on regular basis, I know it can be done by window service but how it can be used with c# and sql server 2005 If any one of you have code than Please Post it. Thanks u all for your support RAHUL TANDON
rahultandon1000 wrote:
As this can be done on regular basis, I know it can be done by window service but how it can be used with c# and sql server 2005
So, what is you problem ? You want to create a Windows services which will regularly check your database and send the notification mail to the user ? If yes, then what is the point to post this question in ASP.NET Forum. You have to create a simple web service, which will call Some SP of of SQL server and retrieve the data from database. By the way you can do all the thing only using SQL server 2005 also ;)