mailing database output to email of endusers

<i><b>Originally posted by : AKHILESHWAR RAY (akhil_ray@mailcity.com)</b></i><br />Dear Friends,<br /> Do any one of you know how to write a script or what has to be done if I want to redirect my output of ACCESS database from screen to email of customers for security reasons.<br /><br />Thank you.<br />

<i><b>Originally posted by : Bianca (bianca@nirve.com)</b></i><br />You need to use the CDONTS object to send email, and you can output anything just like you would output it to a screen. Here's a template:<br /><br /><br />' ======== Starts Send E-mail =======<br />Dim objCDO<br />Set objCDO = Server.CreateObject("CDONTS.NewMail")<br />objCDO.To = "emailaddress@yourdomain.com"<br />objCDO.From = "whatever you want"<br />objCDO.cc = ""<br /> <br />Dim txtSubject<br />txtSubject = "In here you can display anything you want, whether it's ASP output or HTML, doesn't matter."<br /> <br />objCDO.Subject = "Your subject line"<br />objCDO.Body = txtSubject<br />objCDO.Send<br />' ========== Ends Send E-mail ==============<br /><br />Good luck! I just wish someone would help me... <br /><br />Bianca<br /><br />------------<br />AKHILESHWAR RAY at 4/12/2000 12:13:10 AM<br /><br />Dear Friends,<br /> Do any one of you know how to write a script or what has to be done if I want to redirect my output of ACCESS database from screen to email of customers for security reasons.<br /><br />Thank you.<br />