View Single Post
  #2  
Old July 31st 07, 11:36 AM posted to microsoft.public.windows.inetexplorer.ie6_outlookexpress
Steve Cochran
external usenet poster
 
Posts: 2,353
Default Can Excel2003 Read An OE6.0 Email

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




Ads