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:245806
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
