Auto Emailer

Closed Posted Aug 8, 2008 Paid on delivery
Closed Paid on delivery

I need a system that people can manipulate a database using email only.

People can email me a form email with information, and have that info be entered into a database. They also can email me requests for information and have that info be pulled from the database and placed into a auto generated email back to that person.

## Deliverables

These are the exact specs of what I need.

I'm creating a database of names.

The information will be as follows,

1 A name

2 A number to reference which category the name fits into

3 Comments about that entry

4 The date it entered the system

5 The date it expires

6 Which email address entered it into the system

7 Which email addresses the name was assigned to

8 The number of email addresses the name was assigned to

So for example one entry would look like this

Joe Fobes

5

A very strong opportunity for us

09/09/08

09/10/08

joe@[login to view URL]

jim@[login to view URL], Jack@[login to view URL]

2

I will have an email account that will be using gmail as the email server.

I will have people send a blank email to the address. They should get an auto response from that address with the information as to how they can enter information into the system and access information from the system.

For example to submit a name they would send an email that has the name, number, and comment on one line, separated by commas, with each entry on a different line. For example:

Jim Dole, 3, Easy Job

Jack Williams, 2, Easy Job

The program would read that email through communicating to the email server (using pop or imap) or through using an email reader like thunderbird, and enter the relevant information onto the database.

One would be able to request information from the database using a form email that would have the number of requests and the category of requests on a line. Such as:

5, 4

2, 2

18, 3

That translates into 5 requests for category 4 entries, 2 for category 2, and 18 for category 3.

The program reads the email, extracts the information, and generates an email with the information included.

I also would like to create an option that one can choose to get reciprocal information, that for every name in a certain category that one submits, he receives a name in that category.

All names in the database will expire after 30 days, hence the day before names expire I need the program to send out an email to the address that submitted that names or names and ask that person which entries they would like to have renewed.

Also all requests for names will expire after 30 days, hence I need the program to send out an email the day before a requester expires asking him if he would like to receive new names to replace the old ones.

I also want to distribute the names evenly, so if one name has been given out 3 times and the other name has been given out twice, I want the next request to be sent the one that was given out twice.

I would also like to have the outgoing email include a stat of how many names have been distributed thus far.

I also need the capability to edit the form of the outgoing email, so that I can put other information into that email (such as a link, etc.).

Data Entry Engineering Microsoft MySQL PHP Project Management Software Architecture Software Testing Windows Desktop

Project ID: #3123790

About the project

13 proposals Remote project Active Sep 1, 2008

13 freelancers are bidding on average $427 for this job

jacobdd1

See private message.

$255 USD in 14 days
(271 Reviews)
7.1
UmarFarooq

See private message.

$408 USD in 14 days
(63 Reviews)
6.4
sergiles

See private message.

$212.5 USD in 14 days
(71 Reviews)
5.4
bocodevw

See private message.

$386.75 USD in 14 days
(75 Reviews)
6.0
maruidea

See private message.

$255 USD in 14 days
(12 Reviews)
5.1
vw6918430vw

See private message.

$510 USD in 14 days
(9 Reviews)
4.8
azrajobs

See private message.

$637.5 USD in 14 days
(44 Reviews)
4.9
jvavadiya

See private message.

$297.5 USD in 14 days
(19 Reviews)
4.1
basitj

See private message.

$425 USD in 14 days
(13 Reviews)
3.8
remate

See private message.

$85 USD in 14 days
(9 Reviews)
3.2
solutionsprvw

See private message.

$85 USD in 14 days
(0 Reviews)
0.0
rajeshvlx

See private message.

$1700 USD in 14 days
(0 Reviews)
0.0
jplugged

See private message.

$297.5 USD in 14 days
(0 Reviews)
0.0