Send auto mail to all employee on every saturday who have not done training using C #, ASP.NET

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Hello,

I want to desigh web portal in which , i want to send an automail to the employees who haven;t done training . This data is stored in Excel format. Plz help me out ....

The mail will be send on every friday . On every friday it will check for the employees and send to those who haven't attended training.

Thank YOU !!

Posted 31-Jan-13 0:20am

Bhaskar Dhone

Updated 31-Jan-13 1:36am

Joezer BH

v2

Add a Solution

Comments

bbirajdar 31-Jan-13 6:32am

You have posted a complete project requirement here.. The best feasible solution for you will be to hire a asp.net developer

Bhaskar Dhone 31-Jan-13 6:35am

Actually I am new to automail and mail related work in c# and asp.net...it will be helpful if u help me from start..

bbirajdar 31-Jan-13 6:40am

You will need a Windows service that will read the excel data and then send the email at scheduled time on friday.. ASP.NET is not designed to send scheduled emails.. And for the portal, start from here http://aspnetportal.codeplex.com/

Jameel VM 31-Jan-13 6:45am

Create a console application or windows application and run this application(exe) as a scheduler task. Please go through this link for creating Scheduler task in windows http://www.howtogeek.com/51236/how-to-create-modify-and-delete-scheduled-tasks-from-the-command-line/

1 solution

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)

Sandesh M Patil · Accepted Answer · 2013-01-31T01:18:00

Solution 1

Use below steps

1. Create a windows service application.

2. Read the excel sheet data and bind it to dataset.

3. User foreach loop to go through each row of a dataset.

4. if an employee was not attended training, then send an email.

5. Schedule the windows service on Friday on a specific time by using schedular task present in control panel

Posted 31-Jan-13 1:18am

Sandesh M Patil

Comments

Bhaskar Dhone 2-Feb-13 6:02am

how to schedule windows service on friday using task scheduler in control panel ??