saving and emailing a cfr

I've used the cf report builder to generate an excel report driven by a query. The report generates fine but I don't want to display the report in my web page but rather save the generated report to a directory and then cfmail the report to a specific list of people. I've read that saving the reports to disk and emailing is possible by I've found no instruction on how to do this. The normal cffile functions don't seem to work and mimeattaching in cfmail doesn't appear to work either. If anyone has had any experience with this I would greatly appreciate some direction. Thank you.