I created a tool using Visual Studio and the CRM web services that can execute a saved query and then email the results as a CSV file. I’ve presented in a video at www.democrmonline.com/reportscheduler.
There is also sample code at Report Scheduler Sample Code.
With a small change, this tool could be used with the Windows scheduler to run automatically. I left this out intentionally since this code is NOT supported and is as is.
At the least, it’s quick start if you wanted to build your own.