We receive orders as html attachments to emails. We would like to extract a few fields from these html attachments and compile them into 1 txt file at a set time interval (9:00am, 12:00pm, 4:00pm, etc). The process has to be automated. We can have the emails forwarded any way you need.
I attached a sample html file. We would want to extract the following fields:
Order Number: 8676987
Order Date: 2010-09-01
Store No: 10146
Item No.: 10509
Qty: 1
***separate record***
Order Number: 8676987
Order Date: 2010-09-01
Store No: 10146
Item No.: 10503
Qty: 1
5 or 10 email attachments would be compiled into one txt file.
