I have a workbook with five tabs. Each tab has associated with it an import of a tab delimited file. The tab delimited files are produced by running SQL queries against Oracle and saving the results.
This was supposed to be a set of temporary reports but, as I should have known, people like them and want them all the time.
They don't want them set up on a web page they want to have the workbook automatically generated and emailed to them.
I have a server I can run the reports on that is configured with smtp and I have a scheduling package on the box as well.
Suggestions for the "best" way to automate these reports.