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.
## Deliverables
* * *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.