[AccessD] Outlook and Access

Tom:

Thanks. Sounds like a good alternative.  I'll forward to the client.

Best,

Rocky


Tom Keatley wrote:
> 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
>>     
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com