I don't know if this will work, but after you create the file, can you rename it so that the extension is .csv? That will cause Excel to open it, on most systems.
Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -----Original Message----- From: bajaria aslam [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:36 PM To: CF-Talk Subject: Mailing an excel file with <cfmail> Hey List, Thanks for being always helpful. I have one quick question. There is already code that queries the database, then assigns the results to variables using <cfset>. Then it creates a file using <cffile> and inputs these variables in the file with comma in between them, thus creating a comma delimeted string. Then, <cfmail> tag is used to send email with this file as an attachment. The person opening this email will receive this email, then, they will open the attachment in excel. Is there a way to have cf create a excel file using a query output? I need to send a excel file instead of a text file in the email. AB __________________________________________________ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
