Receiving emails for processing in Access

[Guest]

I need to develop an application which will process emails received from
either Eudora or Thunderbird (preferably) or Outlook/Outlook Express. I know
that Eudora has a filter capability to initiate an application upon receipt
of a (filter-passed) email. I don't see that feature in Thunderbird. I am
unfamiliar with Outlook or Outlook Express but I understand that their email
capabilities are similar to Thunderbird.

I'm fairly familiar with VBA, but unfamiliar with whatever features might
exist to import email messages and what message content might be passed from
the listed email clients to the (Access) application. My first thought is to
(boldly) steal them from the client's message file, but that raises all sorts
of questions about how the email client would feel about it, especially if
the emails arrive frequently.

I'm using Access 2003. I'd appreciate any suggestions as to how to do this;
even a pointer to the help files in Access that might five me a clue.

Thanks in advance - Dick

 

[John Nurick]

Hi Dick,

It seems no one here has a good answer. You might do better to ask in
the Access Programming newsgroup.

AFAIK, Outlook Express is a lost cause: it doesn't have any scripting or
automation capability. If you use Outlook as the client, all sorts of
things become possible: you can have Outlook VBA code process the
message and append the data to the Access tables, or have Access VBA
code that gets the messages from Outlook, or use any OLE-compatible
scripting language to automate Outlook and run queries against the
database.

Here are a couple of places to start:

Outlook programming: www.outlookcode.com and www.slipstick.com

Access VBA to get messages from Outlook: sample code at
http://www.fabalou.com/Access/Modules/reading_email.asp