Click here to Skip to main content
13,202,873 members (57,528 online)
Rate this:
Please Sign up or sign in to vote.

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
Updated 31-Jan-13 1:36am
Joezer BH39.1K
aspnet_regiis -i 31-Jan-13 6:32am
You have posted a complete project requirement here.. The best feasible solution for you will be to hire a developer
Bhaskar Dhone 31-Jan-13 6:35am
Actually I am new to automail and mail related work in c# and will be helpful if u help me from start..
aspnet_regiis -i 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
JemiM 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

1 solution

Rate this: bad
Please Sign up or sign in to vote.

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
Bhaskar Dhone 2-Feb-13 6:02am
how to schedule windows service on friday using task scheduler in control panel ??

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.171020.1 | Last Updated 31 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100