The simple solution (but not the *best*): Create the Excel table using very simple HTML in a ColdFusion string buffer (CFSaveContent). Then save that file to a temporary file (CFFile to a file in a temp directory, possibly GetTempDirectory()). Use CFMailParam tag inside of CFMail to attach the File (FILE attribute). Make sure SPOOLING is NOT enabled. Send the email. Delete the temporary file.
You have to make sure not to spool as you might delete the file before the email is sent. If you cannot control this, you can safe the file to a temp directory then just clear that directly periodically (say, every night or so). Does that help? ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Gabrielle Mack [mailto:[EMAIL PROTECTED] Sent: Monday, November 27, 2006 3:40 PM To: CF-Talk Subject: ColdFusion and Microsoft Excel Question: I am a newb to CF and I have been assigned the daunting task of dynamically generating an excel file with absolutely no user action entailed. We currently have code that takes HTML and throws it in an excel file, but the user is prompted to download/save it. We dont want that. I have seen many different solutions given here, but i am not sure which to follow. The overall task is to create and excel file on the fly and then email it out to a user. Any help is appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261780 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
