There is aproblem in establishing connection to DB
Posted on 2004-04-09
I’m writing a macro in VB editor of Microsoft Outlook 2002.
The purpose of the macro is to fire after every mail arrives and checks for certain criteria in the subject field: if it matches with the criteria, then it reads the body of the mail and stores the certain contents in to variables.
Till now I could able to do this.
Now I have to update a table in MSACCESS 97 with these variables.
In continuation of the above macro when I tried to establish a connection to the Access like
Dim adoConn As New ADODB.Connection
Dim adoRS As New ADODB.Recordset
Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
strConn = strConn & "c:\ Mail.mdb"
adoConn.ConnectionString = strConn
It is giving me a compile error
Use defined type not defined
Can any body help me please?