From Email to MS Access DB

[erik4x4]

Hi,

I would like to have an MS OUTLOOK email from a certain user set a
record in MS ACCESS.

That is everytime I get an email notification from a user, well a
different database, I would like that email write to MS ACCESS and add
a record to the database.

I am thinking this must be possible. Anyone with input ?
Thanks

erik4x4

[bm]

Hi,

In order to accomplish this, you need to create interface implementation of
Outlook object model, and bind it to an Access object variable.
This way you can get a notification in Access when an e-mail message is
received in Outlook.
Then you can read the e-mail from Outlook into your Access application, and
if this is the message you are looking for, you can do any processing you
like in Access

If you need more in-depth details on this, you can contact me.

Regards,
Bogdan Zamfir

________________________________
Independent consultant
"erik4x4" <er*****@yepmail.net> wrote in message
news:28**************************@posting.google.c om...

Hi,

I would like to have an MS OUTLOOK email from a certain user set a
record in MS ACCESS.

That is everytime I get an email notification from a user, well a
different database, I would like that email write to MS ACCESS and add
a record to the database.

I am thinking this must be possible. Anyone with input ?
Thanks

erik4x4

[Tony Toews]

er*****@yepmail.net (erik4x4) wrote:

I would like to have an MS OUTLOOK email from a certain user set a
record in MS ACCESS.

That is everytime I get an email notification from a user, well a
different database, I would like that email write to MS ACCESS and add
a record to the database.

I am thinking this must be possible. Anyone with input ?

The most important consideration here is to setup an email account for the exclusive
use of your software. Thus client software, when going against that email account,
won't happily download all these messages for you.

Next see the Outlook specific links at the Access Email FAQ at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm