MS Access And Outlook

I receive 100 emails a day, same subject but with different information in the body. I want to be able to create a process with code that will open every email with the specified subject and populate an access table with the data. (First Name ….Last Name .. ex) It needs like screen scraping and I am not good at it This is how it looks.. Appreciate any help ==============================================BIONIC DIRECTOR LEAD
First Name........Nancy J
Last Name.........Gutzmer
Spouse First......
Spouse Last.......
Telephone No......800 740-2554
Email [email protected]
Lead Source.......
Direct MailRef...............
Ad Code...........
Director...........MaxBenson
==============================================================:blush:

I have a small db that does something like this...

First I created an outlook wizard that launches a db whenever I get an email with a certain subject.

In the access you can link to an outlook folder (either your inbox or another folder that you can have the wizard move your email to).
This linked folder will now be a table; with the use of queries you can append to your table and also delete the email from the linked folder.

Let me know if you need me to send you a copy of my db.

I will really appreciate that

Thanks
:bigyello:

PM your email adrs