asked
Automated Mail
hey hii everyone !!! i have one urgent question, please help me for my below query so that i can make an automated tool for daily absenties people in my office. **following things i have already:** one excel sheet in which we maintain the records of daily absent employee. format of excel sheet is as follows(column wise): employee name(1st column) , employee code(2Nd column), employee's team name(3rd column), employee's supervisor name(4Th column) ,employee's leave type i.e. planned, unplanned(5Th column). we put this excel sheet in specified location. **NOW MY requirement from your side** now i want to write a SQL query that will fetch these records on two basis(1st day basis i.e. daily basis and 2Nd is time(Indian time 1:30 PM)) and send to specified peoples in my office(
shalabh.1.saxena@domain.com, etc) if anyone reply me quick with my solution that will be appreciable. Cheers shalabh
What have you managed to achieve so far? What have you tried?
willam for your more clarification please read my below comments ... i have one excel sheet name as "Absente List.xls". suppose in this excel sheet i have following records as follows: 1st row of excel sheet -------------------------------------------------------------------- "shalabh Saxena" , "522", "Team A", "Shaun(leader name)", "29-08-2011","planned leave" -------------------------------------------------------------------- 2nd row of excel sheet -------------------------------------------------------------------- "sudhakar Saxena" , "529", "Team B", "Shaun(leader name)", "29-08-2011","planned leave" -------------------------------------------------------------------- 3rd row of excel sheet -------------------------------------------------------------------- "Naresh " , "433", "Team E", "Shaun(leader name)", "30-08-2011","planned leave" -------------------------------------------------------------------- 4th row of excel sheet ------------------------------------------------------------------- "Varun " , "528", "Team A", "Shaun(leader name)", "31-08-2011","unplanned leave" ------------------------------------------------------------------- in this format all records are maintained in the "Absentee List.Xls" file. i just want to read this file on date basis(so, that employees will be aware about other persons who are in the office and who are not) and sent to all employees outlook mail at Indian time 1:30 PM. Cheers , shalabh
I would take a look at SSIS for this. You would define the import process, data transformation (if necessary) and finally the emailing of the data to the people needing it. A second possibility would be to do the import with SSIS and use reporting services to provide the final data report. This allows for an up-to-date call of the data, or a subscription based email delivery (whatever the user wants). That would also be a springboard for bringing in that sort of data driven analysis that may be missing in your company. As soon as people see what is possible with SSRS, they generally go crazy and want reports on everything. When that happens, take on the responsibility and become a data hero at your company!
I'm sorry, but a full explanation of what SSRS is and can do is a little out of the scope of this site, may I suggest you take a look at [some videos on the topic][1]. After that, take a go at it and come back here when you get stuck. [1]:
http://www.youtube.com/results?search_query=SSRS+tutorial&aq=f
hey thanks for replying me please read below comment , yo will get more clear idea of my objective i have managed below one thing only... excel sheet in which all absentee employees records are maintained date wise. i just want to know how these records will be sent to different mail id(on my office domain) in table format at indian time 1:30PM
Another way of doing it might be to use OPENQUERY - - to query your excel spreadsheet as a SCHEDULED JOB - . Wrap that up in one of the various DBMAIL routines -
**Thomas thanxs for replying me** but for your more clarification please read my below comments ... i have one excel sheet name as "Absente List.xls". suppose in this excel sheet i have following records as follows: 1st row of excel sheet "shalabh Saxena" , "522", "Team A", "Shaun(leader name)", "29-08-2011","planned leave" 2nd row of excel sheet "sudhakar Saxena" , "529", "Team B", "Shaun(leader name)", "29-08-2011","planned leave" 3rd row of excel sheet "Naresh " , "433", "Team E", "Shaun(leader name)", "30-08-2011","planned leave" 4th row of excel sheet "Varun " , "528", "Team A", "Shaun(leader name)", "31-08-2011","unplanned leave" in this format all records are maintained in the "Absentee List.Xls" file. i just want to read this file on date basis(so, that employees will be aware about other persons who are in the office and who are not) and sent to all employees outlook mail at Indian time 1:30 PM.
That's kind of a quick turnaround to read those articles and decide you still can't do it... what's the problem?
the problem is very clear i just want to send excel sheet information to employees outlook mail id on data basis and at Indian time 1:30 PM i am not familiar with this and seems very challenging to me. so i need others help..will you help me? all these are related to my Love life, if i will do this and i will be hero in her eyes..... so by hook or by cook i need to do cheers shalabh
