Email With Dynamic Attachment

<i><b>Originally posted by : ePoy (epoy@i4free.co.nz)</b></i><br />To all asp expert,<br /><br />I'm fairly new with asp so im not sure if my question is easy or not.<br /><br />Scenario: <br />I have this asp page (a form page) where in i'll be collecting several information base on the user selection; from that information i'll be doing a query to the database, wherein i should be able to produce a *.csv file. This *.csv then will be email as an attachment.<br /><br />Problem.<br />1. I need to email a *.csv file as an attachment, mind you the content of this file is dynamic and im not allow to save any file to a disk/HDD or not permitted to create a physical copy of the file due to security implementation of my client.<br />Is it possible to email dynamic file as an attachment? how?<br /><br />2. What will be my best appoarch in terms of handling the sequence of processes?<br /><br />Thanks you in advance....<br /><br /><br />^e^

<i><b>Originally posted by : (indigo@mail.gr)</b></i><br />Hi there..<br /><br />For your email, I suggest you use the cdonts objects which comes along with IIS..<br /><br />(You can find a cdonts reference in the net)..<br /><br />What you essentially want (in pcode) is:<br /><br />1. User submits your form<br />2. You create the CSV<br />3. You create a new cdonts object and attach the csv to it (use the attachFile method provided by the cdonts).<br />4. Send the email<br />5. free the cdonts object<br />6. redirect the user to another page<br /><br />I think the best practice here is to save it to a temporary file and attach it that way. If you cannot do that then create the csv file as an array in memory, and then use MIME encoding to add the array at the end of your document. <br /><br />Check out the net, there are libraries that provide mime encoding functions.<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />------------<br />ePoy at 4/5/2001 9:54:26 PM<br /><br />To all asp expert,<br /><br />I'm fairly new with asp so im not sure if my question is easy or not.<br /><br />Scenario: <br />I have this asp page (a form page) where in i'll be collecting several information base on the user selection; from that information i'll be doing a query to the database, wherein i should be able to produce a *.csv file. This *.csv then will be email as an attachment.<br /><br />Problem.<br />1. I need to email a *.csv file as an attachment, mind you the content of this file is dynamic and im not allow to save any file to a disk/HDD or not permitted to create a physical copy of the file due to security implementation of my client.<br />Is it possible to email dynamic file as an attachment? how?<br /><br />2. What will be my best appoarch in terms of handling the sequence of processes?<br /><br />Thanks you in advance....<br /><br /><br />^e^