[AccessD] Outlook and Access

Rocky...

Why involve Outlook?

There are command line email clients that will check email on a time scale 
you specify that will save the individual emails to a folder ....you could 
then have an Access Database poll that directory for subject line codes and 
import what it deems important and delete any that are not.

In turn Access could then reply to the emails with a certain code.

The client could be set to NOT delete emails from the server when certain 
criteria were met. That way the email would come in to Outlook as per 
normal.

I had something similar a few years ago for orders. Where it failed (for me) 
was I couldnt get a CONSISTENT subject line in the incoming email . I used 
http://www.infradig.com/postiex/index.shtml

Regards

Tom Keatley


>
> Dear list:
>
> I have a request from a client to program something in Outlook but I
> have no idea where to start.  Quote:
>
> "If an email comes in with a 6 digit (alphanumeric) code in the Subject
> line, Outlook would make a call to Access, passing along the code and
> then delete the email.  No code, email automatically deleted.  The call
> to access would cause the code to be looked up and a status report
> emailed to the client if the code is current. "
>
> I suppose the receipt of any email would have to trigger this hunk of
> code.
>
> I've put a lot of code behind Excel sheets to push data into an Access
> database but never from Outlook.  Does anyone know of any code samples,
> snips, explanations, etc. that could get me started on this?
>
> MTIA,
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com