Outlook to Access

[New2VB]

Greetings Gurus

I would like to try and get received emails into Access. I think the easiest way to do this would be to install Outlook onto the server running the database but I would like some advice please.


What I have is:-

- Exchange2003 server (e.g.blue.red.local or http://mail.red.com) running on Server1
- SQLExpress2005 running on Server2 with a db called Green.
- a table in Green called Requests containing:-

ID = primarykey/autonumber
RequestID = foreignkey to "Main" table
Time = the time the person made the request
Name = name of person sending request
PersonID = the person's identifier
Email = the person's email address
ContactNo = the telephone number of the person sending request
Requirement = what the person wants​

- a form called NewRequest
- a second table in Green called Contacts containing

ID = primarykey/autonumber
ContactsID = foreignkey to "Main" table
Name = name of person sending request
Email = the person's email address
ContactNo = the telephone number of the person sending request​

What I am trying to do is:-
Create a mailbox/mail-enabled public folder called Requests on SERVER1
So,
1. person sends request email to "Requests"
2. database reads new mail in "Requests"
3. database launches NewRequest on receipt of new email (all fields on NewRequest are unbound), populates ID, resolves ContactID (from a Dlookup?), populates the Time, Name & Requirement fields with the matching Received, From & Subject fields in the email
4. recipient enters relevant information in NewRequest and uses an OnClick command-button to save the information to the RequestHistory table.

I think this can be done but if anyone has already done this or knows how to do this I woould greatly appreciate some pointers.

Many thanks as always.