Attaching generated excel file in cfmail

[rollerskatie]

Hi,

I've attached the code in which I've generated an excel file from my data, which the user can then open/save on their PC. I now want to attach this excel file to an email (using cfmail) and send it (the task will then become scheduled).

How do I save rather than output the excel file?

Katie

[Dan_Bracuk]

Using cfcontent does not create an excel file on your server. It gives the user the opportunity to save a .xls file on their local machine, or to view the contents in a version of excel that opens in a browswer. This means it's not available to email using cold fusion.

I know you can create excel files on your server with cf, but I don't know how.

[fober1 · Accepted solution]

Hi,

Have a look at the following tags:

1)
<cfsavecontent> to generate a variable from your tab-delimited content
<cffile action = "write"> to generate a temp file with your content
<cfmail> and attach that file to your email
or
2)
<cfsavecontent>
<cfmail>,<cfmailpart> to attach the variable directly to the email without creating a temp file first (have not tried that myself)

cheers,
fober

[rollerskatie]

Thanks you both, I'll let you know how I get on :)

Katie

[rollerskatie]

Thanks you both, I'll let you know how I get on :)

Katie

[rollerskatie]

Thanks so much Fober! My final code is below..