Re: Creating and emailing excel file without writing a temp file
Im not sure you can do it, however have you investigated the : This example triggers a download of an Excel file. The user will be prompted with an option to save the file or open it in the browser. Once opened they can either save or close on the action of either teh file is then removed from the host, you could maybe add a link to your email so that they can retrieve the excel file not the best solution i know. Jose Diaz On 10/5/06, Peterson, Chris <[EMAIL PROTECTED]> wrote: > > Thanks for the thoughts all, I just ended up writing a temp file and > locking a named variable so I don't have 2 processes overrunning the > same file. > > Chris > > -Original Message- > From: Alan Rother [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 05, 2006 10:03 AM > To: CF-Talk > Subject: Re: Creating and emailing excel file without writing a temp > file > > The problem is, your mail server actually needs to have a physical file > on > an accessible hard drive to send as an attachment. Remember, ColdFusion > does > not send the emails itself, it relies on an SMTP server to do that. > -- > Alan Rother > Adobe Certified Advanced ColdFusion MX 7 Developer > > > > > ~| 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:255669 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating and emailing excel file without writing a temp file
Thanks for the thoughts all, I just ended up writing a temp file and locking a named variable so I don't have 2 processes overrunning the same file. Chris -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Thursday, October 05, 2006 10:03 AM To: CF-Talk Subject: Re: Creating and emailing excel file without writing a temp file The problem is, your mail server actually needs to have a physical file on an accessible hard drive to send as an attachment. Remember, ColdFusion does not send the emails itself, it relies on an SMTP server to do that. -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer ~| 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:255663 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Creating and emailing excel file without writing a temp file
The problem is, your mail server actually needs to have a physical file on an accessible hard drive to send as an attachment. Remember, ColdFusion does not send the emails itself, it relies on an SMTP server to do that. -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer ~| 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:255661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Creating and emailing excel file without writing a temp file
Adkins, Randy wrote: > I do not think you can. Unless you want to write the excel data as the In theory, you SHOULD be able to use to do this.. but I can't get it to work. Play with the following code: This is a test Untitled Column 1 Column 3 Column 2 #RandRange(1000,)# #RandRange(1000,)# #RandRange(1000,)# ~| 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:255637 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating and emailing excel file without writing a temp file
I do not think you can. Unless you want to write the excel data as the email body. Thus no attachment. -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, October 05, 2006 8:38 AM To: CF-Talk Subject: Creating and emailing excel file without writing a temp file I would like to make a quick self-encapsulated cfc to query some data and email off 3 columns in a simple excel file to a list of recipients. Is there a way I can 'write' the excel file in memory and send as an attachment without having to physically write a file using ? Chris ~| 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:255633 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Creating and emailing excel file without writing a temp file
I would like to make a quick self-encapsulated cfc to query some data and email off 3 columns in a simple excel file to a list of recipients. Is there a way I can 'write' the excel file in memory and send as an attachment without having to physically write a file using ? Chris ~| 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:255632 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
