Can Excel2003 Read An Outlook Express6.0 Email?

S

Steve

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get Data From Outlook Express 6.0 Emal? 13
Pull data (sumif?) from an external workbook 2
vba to copy data from sale receipt to next available column in an inventory worksheet 0
add lines to a order list 2
Cell values to an array, then array transpose to another workbook 8
vba to copy data from sale receipt to next available column in aninventory worksheet 0
Help to read and display data 4
Find Multiple Occurence Of Text In A Column 7

Top