Codezwiz >> Forums >> The Board >> Automatic Processing Script

I work for a small business, and we process paperwork that is very repetitive. We receive it via e-mail and it is usually laid out basically the same. The e-mail is on an IMAP server. We use Outlook to check it. We input it into a Retail program (RetailIQ) and save it.

What I need is to know what kind of language to use to write a script to check the mail, whether through outlook or through the server itself, and search for specific titles like "customer name:" and "address:" and information like that and take the data following it (ie: the customers name, the customers address) and enter it into another program's database.

What I basically need is a script or help towards writing said script and extracting the data from the emails. I think I can handle the other half of inputing it into the database, but help on that would be nice. Any ideas, anyone? Thanks for your time, it is much appreciated.

- Evan Mallett

Is it feasible that customers could fill out a web based form instead of sending emails? I could help you build a web-based form that would save the data to a database. It could also kick off emails to whomever you want as a notifier. From there you can export data from the database in whatever format you need and possibly write a script to get data from database-A and dump it to database-B.

Let me know if this is feasible and I'll see what I can do to help.

Well another company actually sends us this data. Any ideas for something extracting the data from the emails? Maybe I COULD make them a simple form to input the data.