Click here to Skip to main content
11,805,604 members (48,113 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL-server-2005 C# ASP.NET , +

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
Edited 31-Jan-13 1:36am
Joezer BH38.3K
aspnet_regiis -i at 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 at 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 at 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 at 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 at 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
0 OriginalGriff 300
1 Richard Deeming 225
2 Sergey Alexandrovich Kryukov 170
3 ppolymorphe 125
4 CPallini 120
0 OriginalGriff 3,265
1 Maciej Los 1,990
2 KrunalRohit 1,907
3 CPallini 1,855
4 Richard MacCutchan 1,227

Advertise | Privacy | Mobile
Web03 | 2.8.151002.1 | Last Updated 31 Jan 2013
Copyright © CodeProject, 1999-2015
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