I have an excel sheet which contains details of my customers whose passports are about to expire.

The excel sheet shows Name, Email Address and Passport expiry date.
I want an auto emailer that will pickup the details from the sheet and email the customer Dear <firstname> - Our records show your passport is about to expire on <ExpiryDate> - blah blah blah.

The receiptient should be able to reply to the email with either:

Yes - pleae contact me i want you to renew my passport
No - I have already renewed my passport and my new expiry date is
No - I dont want to use your service.

We should be notifiied of each response.

If yes - the app should indicate that its a positve response and we then contact him

No - i have renewed already - should update the app with the new expiry date.

No - i dont want your service should remove them or highlight them as not to be contacted.

I should be able to add more details of apps using an excell sheet and your app should remove duplicates and auto email everyone 7 months prior to thier expiry dates. Or i should be able to set a time frame of emailing.



Requirements Interview Answers:
To help you bid more accurately, the buyer was interviewed about the requirements for this bid request. Below are their answers.

Bid request Type: What kind of work do you need done? Software related (Includes desktop applications and internet websites) Bid request Parts: What do you want the worker to do on this bid request? Requirements: The worker will analyze the problem and propose a software-based solution to the problem. Programming: The worker will take the requirements and translate them into the language of the computer (and test it). User installation: The installer will move the software from the place it was created (which is called the development or QC environment) to where you will use it (which is called the production environment). The installer then tests the software to make sure that the installation was done properly and completely. Req. Doc. Type: What kind of documentation do you want for this bid request? Informal documentation - As the buyer talks back and forth about the bid request with the worker, those conversations become the requirements.Remember to communicate ALL of the details of your bid request on the Rent A Coder site. If you don't, and there is a dispute, then important details of the contract will not be documented and cannot be taken into account in arbitration. If you feel you MUST go offsite (for example, using the phone or IM) then afterwards post everything onsite and get the other party to post that they agree to those contractual terms. Program Type: What kind of software should the worker create (and/or install)? An internet web-site: This software runs on a web server and users will access it using their internet browser. A desktop or server program: This software runs on a user's own PC/workstation, or on a server. Internet web-site info Design and functionality: What does the programming of this bid request involve? Design: Create the layout of the pages (or modify the layout of existing pages). Program Functionality: Making the website "work". Modeling another site: Do you wish to model another site? No Size of website: How many pages need to be created/edited in this website? Approximately 3. Programming Language: What programming language(s) do you want your website written in? I don't know what language (and need the worker's assistance to suggest it). Other info:nothing to add. Database: Will this bid request include a database? Yes, it does include a database. Details: Other -- version(s): 1.2 Misc. details: pls recomemend. Browser Type(s)/Version(s): Which browser/version combinations must this website support? IE 7.0 IE 6.0 Server Hosting Environment: What is your server hosting environment? I don't know and need the worker to suggest a 3rd party hosting company server. Server Hosting Environment: Will the worker develop "live" on your server? No. The worker is responsible for creating their own development and/or qc environment. Physical installation: Who will perform the physical installation? The worker will perform the physical installation, and will be given all necessary permissions to do so. Desktop / server program info Size of application: How many screens/forms need to be created/edited in this application? Approximately 3. Programming Language: What programming language(s) do you want your application written in? I don't know what language (and need the worker's assistance to suggest it). Other info:any Operating system(s) What operating systems(s) do you want your application to work on? I do know the operating system(s): Microsoft Windows -- version(s): vista, xp Database: Will this bid request include a database? Yes, it does include a database. Details: Microsoft Access -- version(s): d MySQL -- version(s): d Installation Program: Does the worker need to create an installation program? Yes AND the program will be installed on only a single computer. Legal: 1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future). 2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables): 2a) Any website server-side deliverables must be installed by the Worker in ready-to-run condition in the Buyer's environment. 2b) If there are any server-side deliverables (intended to only exist in one place in the Buyer's environment) then they must be installed by the Worker in ready-to-run condition (unless specified elsewhere by the Buyer). 2c) All other software (including but not limited to any desktop software or software the buyer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request (unless specified elsewhere by the Buyer). 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. 3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the worker's Worker Legal Agreement.

Other Requirements:

---

This broadcast message was sent to all bidders on Friday Apr 30, 2010 4:38:51 AM:

Hi guys (and gals just in case). Please advise what you will make for us. Most of you have reiterated what we want corrrectly and have stated that you can do it. Not really enough. I want to know whether you guys will make a website for us to interact with or will it be a desktop app. Also advise the process of flow in which both instances will work as in. You will upload excel file or you will copy and paste excel data in to website etc. Please tell me what you will make and how it will work. I will be choosing someone by the end of today or tomorrow at the latest.

• All deliverables must be uploaded to Rent A Coder before the deadline(s) for this bid request...with no exceptions. If this contract makes it impossible for a competent person to do this, then do not start this bid request...but instead alert Rent A Coder of an un-arbitratable, illegal bid request.
  
• Remember that contacting the other party outside of the site (by email, phone, etc.) on all business bid requests <$500 (before the buyer's money is escrowed) is a violation of both the software buyer and worker agreements. Rent A Coder monitors all site activity for such violations and can instantly expel transgressors on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.

Categories:
(Note: Like everything else on this page, these categories are part of the original contract for this bid request.)
Web development, Microsoft Windows, Database, Requirements, Operating systems / platforms, Other (Technology), MySQL, Microsoft Access, Software related (includes websites)