|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
December 2nd 08, 06:21 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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 |
|
#2
December 2nd 08, 04:47 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Extracting data from anattachment via VBA | Neil1234567 | Outlook - General Queries | 1 | October 16th 07 10:44 AM |
| Extracting Data from Attachments | mrbalaje | Outlook and VBA | 1 | September 10th 07 07:45 AM |
| Extracting folder data / Outlook won't open | [email protected] | Outlook - General Queries | 4 | March 24th 07 12:41 AM |
| extracting mailitem.body text to Excel columns | Junoon | Outlook and VBA | 3 | April 20th 06 06:45 AM |
| Extracting Public Calendar Information to Excel | WD | Outlook and VBA | 2 | April 19th 06 09:04 PM |
Linear Mode
