[CentOS] help!

Wed Mar 24 08:48:26 UTC 2010
Roland RoLaNd <r_o_l_a_n_d at hotmail.com>

hello,

i've just wrote the following :

more ./*.csv | grep -i XXX | echo "Dear XXX, This email is for informative purposes. Your total number of hours for the week of `date` is: `cut  -d, -f2` hours  Kindly note that the average weekly working hours is : 40." | /usr/sbin/sendEmail -t mail at domain.com -u Test email- disregard it  -f othermail at subdomain.com -s smtp.domain.com:25

this looks in a csv file that exists in the same directory for XX and outputs the field right next to it as you notice from : `cut  -d, -f2` 

It's working pretty fine for just one user, but i have to do the same for 432 person. and its obviously not as professional as it should be due to the following reasons:

1. i have to fill the name for each person in place of XXX as well as their MAIL at domain.com
2. the date command gives the hour as well which is a bit annoying


can anyone guide me on how to proceed? 
as you notice im a bit of a newbie with bash  and im trying my best to improve my one liners/scripts

thanks :)



 		 	   		  
_________________________________________________________________
Hotmail: Trusted email with powerful SPAM protection.
https://signup.live.com/signup.aspx?id=60969