(Repost of previous project)
We need a simple script created to harvest data from emails archived in a folder within Microsoft Outlook Express (NOT standard Outlook). This script will run through approximately 4000 emails in 4 OE Inbox folders and will eliminate manual data entry for transferring values from each notification to an Excel spreadsheet.
Our company receives simple text format email order notifications that have a consistent template (please see below). Each email has a few pieces of data (that is in the exact same place on each email), and this script will copy each value into specific cells / columns in an MS Excel spreadsheet. A sample of the text document (order notification) can be provided upon request.
This script must be safe and cannot cause crashes or bugs in Outlook Express, and may in no way alter the source files. If this project is completed successfully, the programmer will have the opportunity to modify the script to harvest other peices of data from other Outlook Express files for $15 per additional script (we may need up to 5 more scripts for harvesting different data from different folders).
$150 paid in full once functioning product is delivered. Programmers with 10 or more completed projects ONLY. You must be able to write this for OUTLOOK EXPRESS. Already had one programmer who couldn't come through on this project and we need it completed ASAP.
Please Note: We will need an Excel spreadsheet with approx. 8-10 columns to store 8-10 peices of data from each email notification in OE (for example, customer name, phone number, address, order number, total service fees, order date, etc).
This is what the email notification looks like:
===Customer Receipt=== (Seen by customer)
Order ID#: 3304603 - Oct 23 2008 1:58AM
Tickets: 2 x $144.00
Service Fee (varies) 2 x $31.68
Delivery: Standard Delivery $15.00
(Note: Total does not include any applicable state or local sales taxes.)
Event: San Francisco 49ers vs. St. Louis Rams
Location: Candlestick Park, San Francisco, CA
Date/Time: Nov 16 2008 1:05PM
Seats: Section: 16 L-BOX Row: F
40 YARDLINE**ELEVATED 5TH ROW BEHIND 49ERS BENCH**VIP SECTION
Customer: Kelsey XXXXX [[url removed, login to view]]
XXX-XXX-9172 [Daytime] / XXX-XXXX-9172 [Evening]
Card Num: ***********XXXX (Mastercard)
IP Address: [url removed, login to view]
Bill To: Kelsey XXXXX | XXXX XXXXX Street #XX | XXX XXXXXXXXX, CA XXXXX United States of America
Ship To: Same as billing address
***OTHER ORDER INFORMATION***
Alternate: WILL accept equiv/better tickets at same price (if available)
Seller: Action Ticket, LLC - CA | XXX-XXX-XXXX| [url removed, login to view]
===Extra Information=== (Not seen by customer)
Broker: YOU are the holding broker
Available: 2 tickets from 2 in original ticket group
Your Price: 145.00 each $ 290.00
List Price: 144.00 each $ 288.00