I would like some help with creating a way for Outlook to check for subject "Move in a Resident" coming into a particular email address, then parsing the email body data and populating into an access database table. Below is how the body of the email is formatted.
The subject will always be "Move in a Resident"
-- Doe, John D SSN: 000000000
Rent Amount: $700.00
Move In Date: 08/03/2013
Address: 3701 Cimarron Blvd Corpus, Christi, TX 78414
The fields in Microsoft Access Database "Move In" Table "Move In"are
All help will be appreciated. I am using Access and Outlook 2013