well i suppose u must be getting mail-id from your sql for 2 dates and have a recordset of that.

while not RS.eof 
 Set objNewMail = CreateObject("CDONTS.NewMail") 
  objNewMail.Send rs("mail-id"), "sender@company.com", "Hello", _ 
                  "sending this in 3 statements!", 0 ' low importance 
  Set objNewMail = Nothing 
  rs.movenext
loop

it is one of the various ways to use CDONTS. you can explore MSDN to learn more about different properties and methods of CDONTS.
above ex. shows sending mail in one single statement.
If contents of your mail will be same for all, you can make a comma separated string by navigating the recordset and then assign that string to CC property of CDONTS NEWMAIL object.