Access F/E + SQLExpress B/E <> MSExchange2003

[New2VB]

Greetings Gurus,

Access2003 F/E with SQLExpress B/E.

I would like to send email to an Exchange mailbox, have that mail forwarded to a SQL table and link that table to an Access F/E.

I have seen a few articles on how to do this using SQLMail but I can't see anywhere in SQLExpress that allows this.

I could connect each user's Access F/E directly to the public folder containing the email (using linked tables) but I would like the email stored in the SQL db (which I suppose is possible with some kind of Access form OnLoad event vb coding).

I could also install Outlook on the server running SQL and connect each user's F/E to that mailbox and then use the above OnLoad event to "copy" the data to a SQL table.

Could you please advise which of the alternatives is better?

 

[ByteMyzer]

Check out the following link:

How to send e-mail without using SQL Mail in SQL Server

 

[New2VB]

Hi and thanks for your reply,

I may have not explained myself accurately enough so I'll break it down a bit further.

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
- 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, 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 hope this makes more sense than my previous post and apologise if I am over-complicating what may be a fairly simple thing to do. I am trying to learn on-the-fly and don't really know where to start.

Many thanks.