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.


Please do not respond to this confirmation email, as it is for tracking and
record retention purposes only!

************************************************** *************************
This e-mail and any files with it are confidential and are intended solely
for the use of the individual or entity to whom it is addressed. If you are
not the intended recipient or the person responsible for delivering this
e-mail to the intended recipient, be advised that you have received this
e-mail in error and that any use, dissemination, forwarding, printing, or
copying of this e-mail and any file attachment is strictly prohibited. If
you receive this e-mail in error, please immediately reply e-mail to the
sender. You must then destroy the original transmission and its contents.
Thank you.

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.