Extracting data from an e-mail to Excel
 

I am stymied..
I need to extract data from a series of e-mails, in each e-mail there are
two fields that need to be identified, and from those lines the numbers need
to be extracted and placed in a spread sheet for further analysis.

IW numbers would start in A1 and further data added below that, where as ST
would start in B1 and also collect data below that.

I have added a sampling of the e-mail below, if anyone can assist I would be
very grateful.

From: CS Workforce Management
Sent: Monday, November 24, 2008 11:59:40 PM
To: DL BCMS Updates
Subject: CS CQ: 0 OCW: 0:00 :: TS CQ: 0 OCW: 0:00
Auto forwarded by a Rule

CS: 15343/16018 = 95.79% ASA: 1:00

TM: 645/705 = 91.49% ASA: 1:12

GS: 503/507 = 99.21% ASA: 0:15

IW: 1424/2310 = 61.65% ASA: 9:09

ST: 1/2 = 50.00% ASA: 0:31

Total CS Agents Staffed: 28
Total TS Agents Staffed: 12

Extracting data from an e-mail to Excel
 

You can use the Instr function to find the position of a specific text in
the body of the e-mail. Then use the Left, Right, and Mid functions to
extract the text.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Mon, 1 Dec 2008 21:21:00 -0800 schrieb Mahnian:

I am stymied..
I need to extract data from a series of e-mails, in each e-mail there are
two fields that need to be identified, and from those lines the numbers
need
to be extracted and placed in a spread sheet for further analysis.

IW numbers would start in A1 and further data added below that, where as
ST
would start in B1 and also collect data below that.

I have added a sampling of the e-mail below, if anyone can assist I would
be
very grateful.

From: CS Workforce Management
Sent: Monday, November 24, 2008 11:59:40 PM
To: DL BCMS Updates
Subject: CS CQ: 0 OCW: 0:00 :: TS CQ: 0 OCW: 0:00
Auto forwarded by a Rule

CS: 15343/16018 = 95.79% ASA: 1:00

TM: 645/705 = 91.49% ASA: 1:12

GS: 503/507 = 99.21% ASA: 0:15

IW: 1424/2310 = 61.65% ASA: 9:09

ST: 1/2 = 50.00% ASA: 0:31

Total CS Agents Staffed: 28
Total TS Agents Staffed: 12