snake, The file name is "TPHRDataExtractGet.xls". How do you attach it in cfmail??
jl On 7/8/06, Snake <[EMAIL PROTECTED]> wrote: > Wrap it in cfsavecontent, then use cffile to save it. > Then use cfmail to mail it. > > snake > > -----Original Message----- > From: John Lucania [mailto:[EMAIL PROTECTED] > Sent: 08 July 2006 17:54 > To: CF-Talk > Subject: cfmail with attachment > > I need to run this on the Scheduled Task daily. > > bla... > > <cfcontent type="application/vnd.ms-excel"> > <table> > <tr> > <th>employee</th> > <th>firstname</th> > <th>middlename</th> > <th>lastname</th> > <th>addr1</th> > <th>addr2</th> > <th>city</th> > <th>state</th> > <th>zip</th> > <th>hmphonenbr</th> > <th>datehired</th> > <th>termdate</th> > <th>department</th> > <th>departmen2</th> > <th>jobcode</th> > <th>jobdescrip</th> > <th>empstatus</th> > <th>emergconta</th> > <th>emergphone</th> > </tr> > <cfoutput query="GetSourceDemoInfo"> > <tr> > <td>#myemployee#</td> > <td>#myfirstname#</td> > <td>#mymiddlename#</td> > <td>#mylastname#</td> > <td>#myaddr1#</td> > <td>#myaddr2#</td> > <td>#mycity#</td> > <td>#mystate#</td> > <td>#myzip#</td> > <td>#myhmphonenbr#</td> > <td>#mydatehired#</td> > <td>#mytermdate#</td> > <td>#mydepartment#</td> > <td>#mydepartmen2#</td> > <td>#myjobcode#</td> > <td>#myjobdescrip#</td> > <td>#myempstatus#</td> > <td>#myemergconta#</td> > <td>#myemergphone#</td> > </tr> > </cfoutput> > </table> > > bla... > > How do you save the result onto a directory as an Excel file? > Also, how do you e-mail this file as an attachment? > > tia > > jl > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/cf_lists/message.cfm/forumid:4/messageid:245826 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4