My thoughts were to get the WHOLE message into excel format then Excel macro
could be written to move what you desire into a different EXISTING excel
tab. I found many suggestions for this with a simple Google of, email into
excel, but none seems as simple as you seem to want.
For info I get a daily email in .CSV format that I use to open, copy, and
parse in excel.
SG
"Steve" wrote in message
link.net...
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