To build a relationship with technical personnel help create and then distribute reports to our customers requiring ongoing support for updates and expansion of reporting suite.
Background
My company has a number of computerised monitoring systems installed on a variety of heavy mobile equipment. The monitoring systems are programmed to capture information detailing the performance and utilization of the heavy vehicles. This information once captured is then transmitted to a central database over a mobile phone GSM network. We are then able to run reports from the database for our customers. The problem I face is that the database can only run reports using 12.00pm to 12.00pm as the cut off times. This has proved to be extremely limiting to our operation as we need the reports to show the information in a more production orientated format which would typically be two 12 hour periods between 6.00 am to 6.00pm day and nightshift.
Requirement.
I need to have a script written that will automatically take raw data (Excel or csv are the available formats) from list reports sent every day to an outlook account, lay them into an Excel report template supplied by us or by whoever we use to do this and then distribute the subsequent reports again via outlook to our customer base. This whole process needs to be automated from a dedicated computer at our facility in Perth WA.
I hope this makes sense