Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Thu May 11 14:51:24 CDT 2006
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