I need an application which can read through all the emails in an outlook express folder with the intent of finding specific keywords and then to provide me a single csv with the results.
Here is a sample of email contents...
Dear Grant Andrews
**Cxxxx Mxxxx (<cxxxxx@[url removed, login to view]>)** has successfully purchased a subscription from you.
Reference Number: 0D8C6-463C0-A5116
Amount Paid: $[url removed, login to view] USD
Next Payment Date: 1/5/2009
Subscription Number: S-8EA28-89D9C-BB903
Buyer Name: Cxxxx Mxxxx
Buyer Email: <cxxxxx@[url removed, login to view]>
Item Code: Monthly Fee Subscription
Subscription Name: Monthly Fee Subscription
Subscription Description: N/A
Recurring Amount: $[url removed, login to view] USD
Initial Fee: $[url removed, login to view] USD
Frequency: Every month
What I care about and need on each row of a csv file is this
- Customer email address
- Customer first name
- Customer last name
- Reference number
- Subscription number
- FOUND or NOT? FOUND
This software will poll the online database for each person looking for a match. If it is found online then say FOUND, otherwise say NOT FOUND