Need an automated solution
Posted on 2004-10-12
I have a process set up (ASP form) to collect data from an applicant, sent it to an access database, and email it in snapshot format at a certain time every day. This is currently set up with Windows Task Scheduler, which opens FTP to transfer the file from the server at a specific time of day, following which the scheduler runs Access to generate the report and email it in snapshot format, and then scheduler runs FTP again to transfer the updated database back to the server. The issue I'm having with using this method is that all applications are in one report. Ideally, I would like this process to occur each time a new application is submitted. This will allow HR to simply forward the application to the hiring manager. With the current set up, the file has to be printed, scanned, and then forwarded via email in order to only send the appropriate applications to the appropriate managers. Does anyone know of a more efficient way of getting separate applications emailed to HR in a format that resembles the paper application currently in use?