It somewhat depends on what version of CF you are running. CF8 makes things easier, although the older version can handle attachments using the cfmail tag fairly easily. I bet the ColdFusion manual has an example of this. You might also benefit from adding a scheduled task to CF administrator to send emails, depending on what you are trying to achieve.
As far as generating Excel files, I prefer creating native Excel files, as opposed to HTML files that end in .xls, or users will see error messages about the content of the file not matching the file extension. I am not sure about XML though. It might be a good way to go, but I haven't tried it. It is worth a shot, since it should be easier to program than using Apache POI. You can also try cfreport. You might be disappointed with the results of cfreport, but it depends on which version of CF you are running. -Mike Chabot On Dec 18, 2007 3:47 PM, Gabby M <[EMAIL PROTECTED]> wrote: > Hey Guys! > > I thank you for your help in advance. > > Here is my task: > A) Figure out how to generate an excel workbook with multiple worksheets > based on user selections. > B) Figure out how to take that file and automatically email it to the user in > an attachment. > > Now, in my research, I believe I have found the answer here: > http://tutorial429.easycfm.com/ > > As for automatically emailing the file, I am still lost. I have found plenty > of links that give the option for adding an attachment from a form using > MAILTO. However, the user may or may not be accessing a form. We have one > requirement that directs us to automatically generate the excel file based on > user selections from a form and another requirement to have the files > auto-generated before the user comes into work (without the use of any forms). > > So, how do I go about this task? > > Also, is the link provided above, a good route for me to go for? > > Gabby > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3198 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
