The purpose of this project is to e-mail some statistical reports (about 3 to 10 reports) in pdf format. The data come from an Access database already created. The sending must be made automatically on specific dates: every Saturday and every 1st of each month. The sending must be sent to several people that we know of course the e-mails.
We need to:
- use reports already existing and also create new.
- export locally all selected reports (selected according to certain criteria of name, products, ...) one after the other in pdf format.
- send each commercial pdf reports that correspond to his data.
- send to each sector manager pdf reports that correspond to the data of its sector (and sorted according to the commercial he manages) and his individual reports.
Our wishes and constraints
Today, the source database already exists with some reports. Others will have to be created according to our instructions.
We believe that it will use the task scheduler built into Windows 7. Any other solution easy to implement can be accepted. Whatever the tool used, we want the developer, which will be in charge of this project, provide us a clear operating instructions on the installation.
I repeat that all the actions should be done automatically (export reports in pdf format and all sendings).
The project must be absolutely easy to implement and modify.
The database contains statistical reports already created will be provided. It was developed in French. We can provide a translation of certain information if necessary.
The database was developed under Access 2003 and is also used in 2007. User workstations are equipped with Windows 7.