If you want to write your own code to extract the data, you'll need to parse it with basic text functions. The sample at http://www.outlookcode.com/codedetail.aspx?id=89 provides a generic example of some of those functions.

Off-the-shelf tools are listed at http://www.slipstick.com/addins/extract.asp .
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Merge" wrote in message ...
I receive formatted emails like this and i need the following data in an
excel sheet or access, which ever is easiest

Date email was sent
Purchase order number
Confirmation number
Inv Number
Employee
Date
Type
Quantity
Rate
Total



-----Original Message-----
From: xxxxxxx ]
Sent: Thursday, August 23, 2007 10:56 AM
To: abc
Subject: Confirmation Of Successful Invoice Submittal , Confirmation Number:
AABAACCEK8T

Subject: Confirmation Of Successful Invoice Submittal
For: Purchase Order: 5002744915 Line Number: 1, john doe/HR/CONTENT
MANAGEMENT, Effective From 01/01/2007 Thru 01/01/2008

Confirmation Number: AABAACCEK8T



Invoice Num Service Location Employee
Date Type Quantity Rate Total
----------- ----------------------------------------
---------------------------------------- -------------- ---- ----------
---------- ----------
90752-1 corp Services John Doe 08/17/2007 Fri
REGU 32.00 67.65 $2,164.80
----------------------------------------
---------------------------------------- -------------- ---- ----------
---------- ----------

32.00 $2,164.80


Your invoice will be processed within 24 hours of submittal and results will
be displayed within the SWS portal upon completion. The invoice display will
include the date we will submit your invoice to xyz and an estimated payment
date along with details associated with your transaction with xyz.