Sending automated emails to user in sysstem

Question

0.00/5 (No votes)

See more:

Dear All:

I have a management system with users and admin.It is a library system What i want to achieve here is to send reminder as automated mail to user in case if they have borrowed book from library before 1 day of submission day. for an example if the submission day is 10th of august the reminder must come 1 day beforehand that is on 9th of august.

Here my requirement is to send mails using "Outlook".
The system should run @ 9 am first and check the issue details and if there are user in system whose submission date is approaching for that user an automated email from system should be sent.

I dont have idea about batch and schedulers so i don't know how do I actually accomplish this any help would be appreciated.

Posted 8-Aug-11 20:39pm

shoebass

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Van Hua · Answer 1 · 2011-08-08T21:28:00

Solution 1

refer to this article to understand basic send mail method SendMail 101 - How to send e-mails over SMTP (C# and ASP.NET)[^]

when your system run, you can get the list of user whose submission date is approaching and use that article method to send automated email to him/her

Posted 8-Aug-11 21:28pm

Van Hua

Christian Graus · Answer 2 · 2011-08-08T21:35:00

Solution 2

Actually, the article tells you how to send emails, but not how to automate it. Because both your DB and ASP.NET are stateless, your best bet is to build a service that sends emails for you, as it can read your DB to work out what emails need to be sent, and then send them. To use Outlook, you need to use MAPI, not the method described in the article, which sends via a server directly and does not use Outlook.

Posted 8-Aug-11 21:35pm

Christian Graus

Comments

shoebass 9-Aug-11 4:02am

Well the application is developed in C# not Asp . Let me clarify again I have developed a working Library management system and I want to send emails to the user of the system . The user on my system use outlook and the mail address would be something like abc@abc.com . Ok let me tell the other way if some how user forgets the password and if i want to implement "forgot password " functionality in forms what shall i do? If you have any tutorials please send me link.

Kim Togo · Answer 3 · 2011-08-08T23:07:00

Use a SMTP server, perhaps on the Exchange server where the Outlook client connects to send out emails to users.
And then use this tip for sending Sending an Email in C# with or without attachments: generic routine.[^]

Use your MySql to schedule when to send emails out and then use Windows Scheduler to run a program at intervals that you define.

When the program runs, it check with MySql to get all users that has to get an email.

*dan!sh* · Answer 4 · 2011-08-08T23:35:00

Solution 4

You need to create a windows service (preferably) that will periodically poll the database to search for the records where mail is to be sent.

If it finds any reacords, create a message and send it through SMTP or MAPI.

Posted 8-Aug-11 23:35pm

dan!sh