By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,395 Members | 2,541 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,395 IT Pros & Developers. It's quick & easy.

From Email to MS Access DB

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.