Access 2007 code to read incoming emails from Outlook

[Mark Andrews]

Anyone have code to read incoming email messages from ONE email address, or
experience with the functionality in Access2007 to do this process. I have
an upcoming project that will require this and I haven't looked into this
area.

Example: emails that are sent to (e-mail address removed) are added to a table in
the database (everytime the user presses a button or a timer starts a
process). The "body" of the email goes into one field and the "from" email
address goes into another field.

Thanks,
Mark

 

[Orhan Örnek]

Anyone have code to read incoming email messages from ONE email address,
or
experience with the functionality in Access2007 to do this process. I
have
an upcoming project that will require this and I haven't looked into this
area.

Example: emails that are sent to (e-mail address removed) are added to a table in
the database (everytime the user presses a button or a timer starts a
process). The "body" of the email goes into one field and the "from"
email
address goes into another field.

Thanks,
Mark

 

[Paul Shapiro]

Anyone have code to read incoming email messages from ONE email address,
or
experience with the functionality in Access2007 to do this process. I
have
an upcoming project that will require this and I haven't looked into this
area.

Example: emails that are sent to (e-mail address removed) are added to a table in
the database (everytime the user presses a button or a timer starts a
process). The "body" of the email goes into one field and the "from"
email
address goes into another field.

Where do you want this application to read the emails from? Outlook, pop3
server, exchange, etc.?

 

[Mark Andrews]

Outlook

Where do you want this application to read the emails from? Outlook, pop3
server, exchange, etc.?

 

[Paul Shapiro]

You can find plenty of code samples for reading Outlook messages using VBA
with the Outlook object model. Here is a brief example:
http://www.blueclaw-db.com/read_email_access_outlook.htm

This website has been a great resource for any Outlook programming issues:
http://www.slipstick.com/

 

[Mark Andrews]

Thanks for the links.
That should probably work.
Mark

 

[De Jager]

Anyone have code to read incoming email messages from ONE email address,
or
experience with the functionality in Access2007 to do this process. I
have
an upcoming project that will require this and I haven't looked into this
area.

Example: emails that are sent to (e-mail address removed) are added to a table in
the database (everytime the user presses a button or a timer starts a
process). The "body" of the email goes into one field and the "from"
email
address goes into another field.

Thanks,
Mark

 

[joelgeraldine]

ghn jgj,;