Simple Email Autoresponder

Job Description:

I receive hundreds of email responses to job classified postings daily, and I need a system to filter them by the email account they were sent to and then an interface to let me autorespond to selected groups of them.

You'll be building a very small database system to handle the emails, and an PHP frontend to sort them, allow me to view selected groups, and choose a text message to send to those groups. There will be some string processing/regex work involved for parsing the email headers and extracting relevant information.

## Deliverables

Ok, so here goes with the requirements for the autoresponder. It's easiest if I describe the process as a workflow:

1. Person replies to my ad on a classified site, and the email comes to the php handling script on my server.

2. Values such as First Name, Email Address, and a few others are extracted from the email header and stored in a database.

3. I log in (with mild security/authentication) to an interface that shows me all emails received. I can sort them by the fields that we captured in step 2.

4. I can select a group of emails based on a certain field, and go to a page that lets me type a text response to all of them.

5. All emails that I want to respond to are stored in an 'Outbox' table, and sent ~500 at a time.

6. Once an email has been responded to, it is deleted from the Outbox, and marked as 'responded' in the main email table.

Look and feel of the HTML interface is not important, it should be useable and functional.

Additional specifications for some of the steps:

1. I have 7 email accounts, monday@[url removed, login to view],[url removed, login to view] Your email handling script should take emails piped into the script and recognize which of those 7 accounts the email is being forwarded to. See step 2.

2. This is the key step. All emails will be parsed, and information will be stored in a table. The fields needed are:

-First Name (first letter capitalized, if the email has no name, leave blank)

-email address

-account sent to (i.e. Monday, Tuesday, etc., stored as an integer from 1 to 7)

-time received

-replied-to (boolean yes/no, initially no)

-time replied to

-job id (this will be available by parsing an email address in the header)

3. The web interface will let me sort, filter and select emails to respond to based on the fields in (2)

5. This part is necessary because my hosting limits the number of emails I can send per hour. The process would look like this:

Select emails to respond to -> Mark those emails as 'replied to' in the main email table -> store them in the 'Outbox' table -> Send a batch, have an interface to see how many emails remain in the outbox, and the time left until the next send -> Have a button to click to send another batch after an hour -> Delete any sent mails from the Outbox.

That's it. Sorry for the length, I just wanted to be very clear in the spec. I've attached a script that I wrote using to do some email piping/processing (with my database details removed).

I can provide an account to test the script on if necessary.

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Sobre o Cliente:
( 1 comentário ) United States

ID do Projeto: #3524170

Concedido a:


See private message.

$10 USD em 1 dia
(13 Comentários)