Super, Daniel! John
On 7/8/06, Daniel Kang <[EMAIL PROTECTED]> wrote: > John, > > <cfmailparam file="TPHRDataExtractGet.xls"> > > Hope this helps! > > Daniel > > On 7/8/06, John Lucania <[EMAIL PROTECTED]> wrote: > > 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:245829 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4