Watch Outlook Folder for e-mail then launch Access-DB using e-mail data, and reply.
Posted on 2008-11-07
What I would like to do is set up a 'watch' on a specific Outlook Mailbox.
If the subject contains, for example: "My Telephone Report: 555-555-5555". Then it would launch an Access database, and run a report with the "555-555-5555" criteria, and e-mail the results back.
I'm assuming this would consist of watching the e-mails, and saving the variable to a file. Then launching the Access-DB which would pick up the file/variable, link it into the query, and run the query. The results would likely have to be always replied to the same person, or a folder where it can be picked up... ?
Any other ideas on how to accomplish this?