OK, i created a watc process that look in a folder for a filename. It takes the file and does a splitter for a word at a specific location.
I am doing a jobinfo 1 for a repname. Now i need to lookup the repname's email address in an access mdb file that i have living on the planet watch server. ther file is c:\estate\estate2k.mdb. it contains one table with two columns. the columns are repnum and email. whats the script look like to take the %1 and lookup the corresponging email in the table and then return the email value to %9.

here is waht i have so far.
dim strConnect, oDB
strConnect="DSN=estate;APP=PlanetPress Suite 5;DATABASE=c:\estate\estate2k.mdb;UID=user;PWD=pass"

' Initialize DB
set ODB = CreateObject("ADODB.Connection")
oDB.Open strConnect