Email Reminder

Posted by Krish_17nov under Regular Expressions on 3/27/2009 | Views : 5040 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi all,
I am having a customer table having its name and date of joining. I want that the system automatically send a E-mail reminder
before a week of its membership expiration date, if the membership is for one year in that case the system will automatically send a mail
before a week to the client to rejoin the system.

I am using dot net 3.5 and sql server 2005.

please send me the response.

Thanks

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Raja on: 3/28/2009 [Member] Starter

0	You can write a SQL Server jobs that will keep running and checking the database table for the member ship status and as soon as it will find some member's expiry within a week, it will send an email. OR You can write a separate Windows Service application that will run in background and check for the same. Thanks Regards, Raja, USA Krish_17nov, if this helps please login to Mark As Answer. \| Alert Moderator

You can write a SQL Server jobs that will keep running and checking the database table for the member ship status and as soon as it will find some member's expiry within a week, it will send an email.

OR

You can write a separate Windows Service application that will run in background and check for the same.

Thanks

Regards,
Raja, USA

Krish_17nov, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Neeks on: 3/31/2009 [Member] Bronze

0	You can complete this site using the Windows service functionality provided by the .Net. Please follow the Given link for the Sample creating the Windows service http://www.c-sharpcorner.com/Articles/ArticleListing.aspx?SectionID=1&SubSectionID=78 Krish_17nov, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts