Here is some code to get you started.  You will need to add a reference to
the Microsoft xx.x Outlook Object Library and the Microsoft DAO x.xx Object
Library appropriate to the version of Office that you are using.

Dim oApp As Outlook.Application
Dim objNewMail As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient
Dim db as DAO.Database
Dim rs As DAO.Recordset
Dim strSQL as String

Set oApp = New Outlook.Application

strSQL = "Select [email] from MyTable WHERE ..."
Set db = CurrentDB
Set rs = db.OpenRecordset(strSQL, DBOpenDynaset)

Set objNewMail = oApp.CreateItem(olMailItem)
With objNewMail
   rs.MoveFirst
  ' All recipients will get the same email
   Do While Not rs.EOF
       If Len(Trim(rs!email)) > 0 Then
           Set objOutlookRecip = .Recipients.Add(rs!email)
           objOutlookRecip.Type = olTo
       End If
       rs.MoveNext
   Loop
   .Subject = "Your subject here."
   .Body = "Your text message here."
   .Save
   .Send
End With

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX