Processing incoming email messages

[news2]

I need to prepare an access procedure which will receive and process e-mail
messages delivered to it from an e-mail client. I have the clients Eudora
and Thunderbird with which I am quite familiar, and of course the outlook
pair with which I am somewhat unfamiliar. I'm aware that Eudora can
initiate an application as the result of a filter, but have no idea if/how
Access can get it's hands on the message content for processing.

I'd appreciate any pointers as to how to handle this. I suspect that simply
"stealing" the message file from the client would not be satisfactory due to
potential interference with the client processing. That is, suppose a
message arrived while Access was in the process of stealing.

Thanks in advance - Dick

 

[Paul Shapiro]

I've done this with Outlook by writing an Outlook rule to move the desired
incoming messages into a particular mail folder. Then the loading process is
done from within Access. Access creates an Outlook object and gets the mail
folder that contains those messages. Then it processes all mail in that
folder, moving it to another folder as it's processed. I haven't used Eudora
for some years, but I think it can be controlled via OLE, so you could
probably do the same thing. Don't know about Thunderbird.
Paul Shapiro

 

[Tony Toews [MVP]]

I need to prepare an access procedure which will receive and process e-mail
messages delivered to it from an e-mail client. I have the clients Eudora
and Thunderbird with which I am quite familiar, and of course the outlook
pair with which I am somewhat unfamiliar. I'm aware that Eudora can
initiate an application as the result of a filter, but have no idea if/how
Access can get it's hands on the message content for processing.

I'd appreciate any pointers as to how to handle this. I suspect that simply
"stealing" the message file from the client would not be satisfactory due to
potential interference with the client processing. That is, suppose a
message arrived while Access was in the process of stealing.

Agreed. If at all possible use POP3 and SMTP protocols to receive
and send emails. I'd suggest a dedicated email address used just for
this purpose.

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

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