Export Outlook emails to Access & parse certain text elements
Hello,
I am a newbie.
I have a task ahead of me, where I need to automate a process such that certain elements from incoming emails get populated as columns in a database.
An example email is as follows:
Date: Tue, 17 Jan 2012 11:56:03 -0600
Subject: [MySystem -XYZ] – Error obtaining data from EDHJ <<1010109090
Team,
There is some text here. About two or three lines.
Reminder =
New Employee Name = Doe , John
New Employee Login = JII8990
Environment = TEST
I need to extract only the following elements from the email & populate a database:
Tue, 17 Jan 2012 11:56:03 -0600
Error obtaining data from EDHJ
1010109090
Doe , John
JII8990
Any ideas how I could do this? Your help is very, very appreciated.
Thanks.
Sandra
|