Develop a software that runs on a Windows server in Excel 2010 (VBA) Project summary: The software receives emails from Gmail account(s) Analyses the message according to rules Logs incoming emails for statistics on an Excel sheet Creates Replies using a template, data from the Excel document , data extracted from the received email Sends the reply by email Project implementation: We, the buyer, will provide a server with Excel installed. You, the seller, will develop the code on this server or add developed code daily. You will also report daily what work has been done and which milestones have been accomplished. You will document the code and additionally installed software segments (like drivers, software libraries etc so we will be able to install/copy the final version of the software on a different server. Phase 1 (see below) is to be completed within 1 week after winning the auction. For details see: "Detailed requirements" below
Project details: Phase 1: Email Engine To be completed till end of Day 1: Create Excel document with sheet data_Accounts, data_Email, Data_Reply. Create a program with a loop starting ever 5 minutes and calls prg_EmailReceiveAll and prg_EmailDelete. To be completed till end of Day 3: Create a program prg_EmailReceiveAll that loops as long as unread emails are found. It downloads oldest unread email from Gmail account, marks it as read, stores content and details to sheet data_Email, start sub routine prg_CreateReply. To be completed till end of Day 5: Create prg_CreateReply that fills Data_Reply with dummy data made from received email. Create a program sending content from Data_Reply using account details stored in sheet data_Accounts. To be completed till end of Day 6: Create prg_EmailDelete that moves all read email to trash. Details about the final Excel file design: 1 sheet with gmail account details (data_Accounts) [several email accounts?] 1 sheet for content of received email (data_Email) 1 sheet with rules to categorize incoming emails (data_CategoryRules) [platforms] [distribution of updates?] 1 sheet with rules to analyze incoming emails per category (data_ParseRules) [distribution of updates?] 1 sheet to store values found in the received email (values) 1 sheet providing the content and data to reply to the email (Data_Reply) 1 sheet to store values found in email for statistics (data_Statistic) 1 code segment to create the content for the reply email (prg_Merge) More details about the whole project (only phase 1 (see above) is object to this auction): Phase 2.1: Categorizing - Analyzes the email content which rules apply to determine - how to extract and reformat values (especially dates) - which template to use for reply Phase 2.2: Analyzing - Apply roles to find values in email content Phase 2.3: Check availability - download giving html page and analyse Phase 3: Merging - Module exists Phase 4.1: Watchdog - create heart beat - Loading the local time as string on a web site Phase 4.2: Watchdog - check other heat beats - Check a list of web sites - Create email if a web site did not change within 15 minutes Phase 5: automatic updates - Create a program prg_Update that downloads a website (URL to be found on data_Accounts) and store values found at the given location in Excel.