Click to See Complete Forum and Search --> : Collecting Email addresses on Website
Wulvyn
07-16-2008, 09:48 AM
Hi all,
I have a question about how I might be able to allow registrants to enter email addresses on our website, collect them in Outlook or some other address book, and send mass emails in the future.
I am not very savvy when it comes to building a website but I can enter code and do some of the behind the scenes things. I am looking for a form or a way for parents to enter in their email address on my site so that they can be reminded at a later date in the future with a mass mailing.
It would be great if these emails could be collected in some type of an address book but even in a form it would be good too. There will most likely be 1000+ emails that I will be receiving and to do all of those by hand would be a logistical nightmare.
If anyone out there knows of a script or could even develop one, we would be grateful.
Wulvyn
ryanbutler
07-16-2008, 12:27 PM
One approach I've used before with ASP.NET is using a database table to store their email address. The database would also store an ID and a date time field. You could then create a form that allows parents to fill in their email address and once inserted goes into the database.
Then you could write a simplistic web form with a send button. The web form with a send button could issue two queries, one query would be to select all email addresses where the date time of the database table field is null, the other would issue an update statement to the time sent field and set the where clause to the unique id (primary key).
You would then loop through the first result set and send the mail to multiple people. The second result set would simply update the time sent variable to ensure that only one email would be sent to each person.
--------------------------------
The easier way may just be to purchase a mailing list application that does this for you. I'm sure some might exist, it would just taking Googling a bit.
I have a possible solution for you,... [Edited by admin. Keep all replies on the forums.]
eCat
We need to keep the replies here, on the forums for others to see also.
One suggestion for gathering e-mails is to have a mailing list program that also sends them out, i.e. Dada Mail (http://www.google.com/url?sa=t&ct=res&cd=1&url=http%3A%2F%2Fdadamailproject.com%2F&ei=amB-SJ2lKo2GgwSf6pGwAg&usg=AFQjCNHnCkkxwrv9RZeTbKWOKi-4lcV6pQ&sig2=dKs09zmboo4fu4Y20eFYWw).
slaughters
07-16-2008, 05:30 PM
SPAM is evil.
Make sure you ask the registrants if they want to 'opt out' of the mass e-mail
Mr. E. Cryptic
07-16-2008, 05:45 PM
SPAM is evil.
Make sure you ask the registrants if they want to 'opt out' of the mass e-mail
always good to also make sure they're the ones opting in in the first place - double opt-in (http://www.php-scripts.com/php_diary/011103.php3)
Ok - let's try this again... :rolleyes:
This software will allow you to create a simple form that you can use to collect the email addresses and then export the data to Outlook or whatever. You just need to have MySQL and PHP on your web host server. The software does the rest:
www.SeaGreenSoftware.com
DISCLAIMER!
This is my own website and my own software, but I was told I could post it in this particular thread since that's not why I post in these forums. I just want to help solve Wulvyn's problem. :D
DISCLAIMER!
Moderator: please feel free to edit my post if I did anything wrong here.