View Single Post
  #1  
Old December 2nd 08, 06:21 AM posted to microsoft.public.outlook.program_vba
Mahnian
external usenet poster
 
Posts: 1
Default 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

Ads