Email Auto Reply in Excel


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

## Deliverables

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.

Skills: Script Install, Shell Script, Software Architecture, Windows Desktop

See more: web page requirements document template, web content downloads, vba extract data from website, vba code to extract data from website, template of heart, template libraries, reformat data, how to download develop website, how to develop website using html, how to develop website in html, how to develop website and email, how to develop a website using html, heart design template, gmail module, extract data from website using vba, extract data from website to excel vba, excel sites, dummy content for website, downloads site html 5, download develop html, design a website in 2 minutes, create website like gmail, categorizing software, categorize software, by design auto

Project ID: #2750213

7 freelancers are bidding on average $295 for this job


See private message.

$297.5 USD in 14 days
(20 Reviews)

See private message.

$420 USD in 14 days
(31 Reviews)

See private message.

$350.2 USD in 14 days
(6 Reviews)

See private message.

$289 USD in 14 days
(10 Reviews)

See private message.

$225.25 USD in 14 days
(3 Reviews)

See private message.

$300.05 USD in 14 days
(0 Reviews)

See private message.

$180.2 USD in 14 days
(0 Reviews)