I suggest you brush up on your perl, and then take a look at the CPAN, search for excel modules, and a module for whatever you use to send email.
Install them using perl -MCPAN -e'install XML::Excel'
(XML::Excel is the module you want)
This sounds like a very interesting project. When I get home, I'm going to play around with the idea of opening up Excel files with perl.
Let us know how this goes.