QueryToDoc Command Line Publisher Tutorial
Command line driven version of QueryToDoc lets you run a query on the schedule you select. Save the output - Excel, Word, HTML, CSV - to a shared drive or automatically mail it to recipients as an e-mail attachment.
1. Store your queries in text files
2. Define database connections, output type (Word, Excel, HTML, CSV), output file locations, and e-mail recipients in an ini file of parameters. This file also contains a link to the file that holds the query you want to use.
3. Run the program from the command line
4. To export and deliver reports on a schedule, start by creating a cmd file that points to the parameter file you want to use:
Then use Windows Scheduler to run the program on the schedule you define:
5. Each time you run the program it creates a log file that documents success or failure.
