Reading Outlook2010 New EMail Bodies and sending pieces to Access 2010 table
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.
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.
ASKER
I would prefer automatically. The parse part as new mail comes in, the creation of the new mail at a specified time....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks so much!
That was EXCELLENT!
That was EXCELLENT!
You're welcome!
Do you want the solution to run automatically (like an Outlook rule) or do you want to run it manually.