sending emails to multiple users in access database at one go.

<i><b>Originally posted by : navin dulani (navindulani@hotmail.com)</b></i><br />******************* URGENT ********************<br /><br />i have an Access database that has registered users with their email-ids.<br />i used the CDONTS object to send email one at a time.<br /><br />How do i modify the code to send emails to all these users at one go.<br />can anyone please help ?<br /><br />regards<br />navin dulani.

<i><b>Originally posted by : Ramkumar Raja (vvrkumar@yahoo.com)</b></i><br />Hai Navin,<br /><br />Its very simple by using CDONTS component. This component has one property named CC.<br /><br />Syntax:<br /><br />objMail = server.createobject("CDONTS.NewMail")<br />objMail.To = address1 'Any address<br />objMail.cc = "mailto:add1@add.com;add2@add.com;add3@mail.com" 'More than one address<br />objMail.body = "Message"<br />objMail.Send<br /><br />Got it!!!!, Just U get the data from Access and separate it by semicolon(thats your logic)<br /><br />regards,<br />Ramkumar raja<br /><br />------------<br />navin dulani at 3/1/2000 3:46:56 PM<br /><br />******************* URGENT ********************<br /><br />i have an Access database that has registered users with their email-ids.<br />i used the CDONTS object to send email one at a time.<br /><br />How do i modify the code to send emails to all these users at one go.<br />can anyone please help ?<br /><br />regards<br />navin dulani.