Connection string and SQL statement - I am new to this!

[VbPanicStation]

Hi,
Please help!!! I have not used ado connection strings and SQL statements before so I am really stuck.
What I am trying to do is access some tables/ query within the same ACCESS 2003/ 2000 database using VBA and then use the data to send out an 'automatic' email.

Questions:
1. How do I set up a connection string in VBA such that I can access the data in the tables within the same ACCESS database?

2. How do I write and run the SQL statements to retrieve the data?

PLEASE HELP!!

 

[VbPanicStation]

.

 

[Zion7]

VPS, there are countless web sites to find this info....
Dim SQL As String, rec As New ADODB.Recordset
SQL = "SELECT txtName, txtEmail FROM tblContacts " & _
"WHERE txtDateSent Is Null"

rec.open SQL, CurrentProject.Connection, adOpenForwardOnly,adLockPessimistic

rec.Close: Set rec = Nothing