We have an ecommerce website and would like to setup an asp based email blast to these customers at set intervals since they purchased (30 days, 60 days, 90 days).?
The web app must be written in Classic? ASP.
It should have a basic html editor with the ability to edit source.? This can be a free control that's already available instead of recreating this function.
You should be able to save the html emails in a SQL Database.
The user will then choose the saved email to send to users then select the group to send it to (30 day,? 60, etc.)
It should also have a function? to send a test message to a single email address.
It should grab the email addresses? from an orders table and it should do the following
Depending on the group to send to, this example uses 30 day-? It? should query the orders table for emails that ordered from 30 -? 59 days that have not re-ordered and have not? already? been sent the 30 day email.? To accomplish this, we will include new fields in the table called 30_email_sent, 60_email_sent, 90_email_set, etc.? When the email is sent to the customer, it will populate that field with the date that it was sent.? ?
This must be in an nice interface and can be done with AJAX if need be.?
Please include? in your estimate any additional features you believe need to be in this.