outlook -> Access vba question

[blastman]

hi guys,

I'm writing some VBA code in outlook and I'm after a little help.

In access, I have a database called "Customers" with one table within it called "New Customers" This table has 9 fields, first-name, last-name, home number, mobile number, appointment date, appointment time, city and description.

In my outlook code I have 9 filled variables called, lanme, fname, homenum, mobile, apdate, aptime, city and descript. (which are pulled from a FTP site after a email comes in with a certain subject) I like to be able to fill the fields of my database with these variables from outlook.

This is even possible???

Can anyone point me in the right direction??

 

[blastman]

Ok,

So i've created a connection in ODBC, and used the code below to connect to it.

Set objADOConn = CreateObject("ADODB.Connection")
objADOConn.Open "DSN=ocs"

As I understand it, I'm suposed to use a recordset and a SQL statement. Sad thing is, i have no ideas what either of these are/should be !!!

 

[RockLobster]

Try this http://support.microsoft.com/?kbid=290792

Also code16 may help - http://www.helenfeddema.com/CodeSamples.htm#Code16