**Core function**: An application to process emails (matching certain criteria) from POP3 account every X seconds. The emails are derived from web forms and contain formatted text fieldname and value pairs. The fieldnames in the emails are searched for in the table of an ADO database, if found the corresponding value is written to a new record as the correct data type. When the email has finished being processed the record is posted. If a record can’t be posted the email is forwarded to another email address for manual input to the database. Once record has been successfully posted an external application of user choice must be opened.
The fieldnames and datatypes of the destination database are unknown. All that is given by the user is the connectionstring and table name.
**Please see attached Word document or text file for further information.**
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Code must use only Delphi 5 VCL/RTL and Indy Internet components if required. Any other VCL/Active X must be approved first.
2) All code must be fully documented and commented in order to allow future development.
3) Complete ownership and distribution copyrights to all work purchased.
Windows 9x or greater (Win32)
User can specify any ADO db as local application database.
User can specify any ADO db as destination db.