Can Excel2003 Read An OE6.0 Email
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
|