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.