Create email processing application

Standalone application to check POP3 mailbox for emails of a certain subject line, then download the email and process the body text, which is XML text. Data from the body text contains information to insert, update, or delete data in a SQLServer database. ## Deliverables Functions: 1. Read designated email box for list of emails 2. Download messages from email box 3. Process email messages from box 1. Validate subject line 2. Read email body 3. Process transactions in body text 4. Data in email interact with a database i. Insert ii. Update iii. Delete iv. Exec (used to call a stored procedure and pass variables from the email) 1. 1. Delete email from mailbox at conclusion of successful processing 2. Log all activities to text log file 1. Processing log i. Date & time ii. Action iii. Result 1. Errors in process creates separate error log, one log per day Application runs as a service, with timed check of the designated mailbox Application uses a configuration file ([login to view URL]) a. Email settings b. Process settings c. Database settings d. Data format settings