|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
July 31st 07, 02:55 AM
posted to microsoft.public.windows.inetexplorer.ie6_outlookexpress
|
|||
|
|||
Can Excel2003 Read An OE6.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 
|
| Ads |
|
#2
July 31st 07, 11:36 AM
posted to microsoft.public.windows.inetexplorer.ie6_outlookexpress
|
|||
|
|||
|
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
|
|
#3
July 31st 07, 01:02 PM
posted to microsoft.public.windows.inetexplorer.ie6_outlookexpress
|
|||
|
|||
|
Can Excel2003 Read An OE6.0 Email
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
|
|
#4
July 31st 07, 07:01 PM
posted to microsoft.public.windows.inetexplorer.ie6_outlookexpress
|
|||
|
|||
|
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
|
|
#5
July 31st 07, 09:53 PM
posted to microsoft.public.windows.inetexplorer.ie6_outlookexpress
|
|||
|
|||
|
Can Excel2003 Read An OE6.0 Email
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
|
|
#6
August 1st 07, 12:42 AM
posted to microsoft.public.windows.inetexplorer.ie6_outlookexpress
|
|||
|
|||
|
Can Excel2003 Read An OE6.0 Email
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
|
|
#7
August 1st 07, 12:38 PM
posted to microsoft.public.windows.inetexplorer.ie6_outlookexpress
|
|||
|
|||
|
Can Excel2003 Read An OE6.0 Email
My DBXtract or DBXpress programs (or OEX) will extract the messages: see
www.oehelp.com steve "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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| email missing right after I read it! | Bob Mendenall | Outlook Express | 2 | June 14th 07 12:48 AM |
| Email addresses do not read properly | Sheila Brister | Outlook - Using Contacts | 1 | January 29th 07 08:56 PM |
| Importing excel2003 file into outlook2003 | [email protected] | Outlook - Using Contacts | 0 | October 27th 06 06:39 AM |
| POP Server Email Read Flag? | news.onenet.net | Outlook - General Queries | 1 | October 14th 06 10:20 PM |
| verify that an email was read without using a receipt | RCNellis | Outlook - General Queries | 1 | May 12th 06 04:02 PM |
Linear Mode
