View Single Post
 
Old 01-18-2012, 09:30 PM
smahale smahale is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Jan 2012
Posts: 1
smahale is on a distinguished road
Default 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
Reply With Quote