I have created some software for quoting and order fulfillment in MS Access 2007. I want to be able to select an email in Outlook's Inbox, hit a custom button which then checks the sender's email address in my Access database. It should then present a list of all orders associated with that email address and allow the user to select one of them. Once selected, a copy of the email will then be created in the database against that order.
I'm after some guidance on the best way to do this. My Access Database is split with a frontend and a backend. I'm experienced with VBA in MS Access, but have very limited experience with such integration tasks. Hopefully with a little guidance I'll be able to figure the rest out.