Reading Outlook2010 New EMail Bodies and sending pieces to Access 2010 table
Posted on 2013-06-25
I'm pretty good at Access vba, but havent explored much with Outlook
I get a certain amount of emails coming in mentioning jobs. Each mail message contains a formated body that I would like to parse, place into a database if it is a new one and then notify me of only the new jobs.
I would like to do this from Outlook 2010 so it would work like this:
1) Extract body
2) Is it from a Job_Sender in the Access Table
3) If so, parse Body
4) Take Job title, company, location, date of message, and link.
5) Store in Access table if these are new.
6) Compose new email to me daily at a certain time (4pm) that just lists the new items
Where do I place the code ?
How can I get to the new bodies only?
Can I get to hyperlinks within the body?
Any help would be appreciated.