Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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 1:20am
Edited 31-Jan-13 2:36am
v2
Comments
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 asp.net developer
Bhaskar Dhone at 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..
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 http://aspnetportal.codeplex.com/
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 http://www.howtogeek.com/51236/how-to-create-modify-and-delete-scheduled-tasks-from-the-command-line/

1 solution

Rate this: bad
good
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
  Permalink  
Comments
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 200
1 PIEBALDconsult 150
2 BillWoodruff 148
3 Jochen Arndt 135
4 DamithSL 130
0 OriginalGriff 5,695
1 DamithSL 4,506
2 Maciej Los 4,007
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,190


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 31 Jan 2013
Copyright © CodeProject, 1999-2014
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