ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can Excel2003 Read An Outlook Express6.0 Email? (https://www.excelbanter.com/excel-programming/394461-can-excel2003-read-outlook-express6-0-email.html)

Steve[_91_]

Can Excel2003 Read An Outlook Express6.0 Email?
 
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




All times are GMT +1. The time now is 07:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com