SG,

Thanks for responding!

I don't understanf why you copied and pasted my example into Excel. It is an
Outlook Express 6.0 email message. I am searching for a a way to read the
Outlook Express 6.0 email message, get the product code and Qty from the
email message and enter them into an Excel2003 worksheet.

Any ideas on how to programatically get data out of an OE 6.0 email?

Thanks!

Steve


"shakey" shakeyATsonic.net wrote in message
...
I just copied your sample and pasted it into excel 2003. From there it
looks like a simple job to make excel do as you wish many times. Go to a
Excel group for help, they have helped me a lot.
SG
"Steve" wrote in message
k.net...
Steve,

Thanks for responding!

How do I extract the message?

Steve


"Steve Cochran" wrote in message
...
You would need probably to extract the messages and then a customized
program would have to be written to parse the fields in the message
text.

steve

"Steve" wrote in message
ink.net...
Orders from a shopping cart are received by email using Outlook Express
6.0.
All email orders have the same format:

------------
Sales Order Date and Time
-----------

DELIVER TO:
.....
....
....

Make payable to:
.......
........
.........

ORDERED ITEMS:
6 character product code: Product description
product category
Qty: 4 at $26.96

Can this email be read from Excel 2003 and get the product code and
save it
to cell A1 in Worksheet Order Items in Workbook Sales and get the 4
after
Qty: and save it to cell B1 in Worksheet Order Items in Workbook Sales?

Thanks!

Steve