Questions about generating Excel files via CF
Posted on 2006-04-25
We have a client that has requested that data be sent to them in Excel format on a weekly basis. What I would like to do is create one piece of code that I will setup through the CF administrator as a Scheduled Program to be run when they would like. What I want this code to do is query data, generate an excel file with that data and save it to the server, then e-mail that file to our client. I already did the research and found out how to create an excel file on the fly, so I have the code that generates and formats exactly how I want it, however I manually have to hit that cfm file so that I can get the dialog box to open/save the excel file I generated. I also have created apps that send e-mails out, however I have never sent one via CF that had an attachment. So I guess the 2 main things I need help with are automatically saving the generated excel file to the server, and attaching that to an e-mail I will send out via CF.
I would greatly appreciate anything that would point me in the right direction, I really don't want to manually save and attach this file on a weekly basis like I will have to do until I can get this figured out.
Thanks in advance,