Sending Multiple Emails

Hi Everyone<br><br>I have a table in database called personal_details with many fields including email, now I want to send multiple email to the users getting the values from the database. Now depending on the number of emails and records per page there should be a paging and when I start clicking the number that respective emails should go i.e. there are 100 emails in the table and the navigation is based on 10 emails per page so there will be 10 pages i.e. 1,2,3,...,10. Now when I click on 1 emails to first ten email address should go, when I click on 2 emails to next 10 emai address should go and so on. How can I do so. I am using VB.NET.<br><br><br>Thanks in advance,<br>Uday.

Make DB Connection, get all the Records, concatenate the EMailIDs in to a Single variable<br>say the variable is AllUsersEMailID = "user1@somemail.com,user2@somemail.com,user3@somema il.com"...<br><br>Some Exchange Server uses "," a7 some ";" as seperator. you might want to check that.<br><br>Rest is here<br><br>Dim objMsg<br>Set objMsg =wscript.CreateObject("CDO.Message")<br>With objMsg<br> .From = "YourEMailAlias"<br> .To = AllUsersEMailID <br> .Subject = "Some Subject"<br> .HTMLBody = "HTML Content If any"<br> .TextBody = "Message of the Email"<br> .Send<br>End With