Looking for advice on best approach considering my needs and abilities.
I am the web developer and webmaster for a dance club with 300 members and a mailing list of 500. Might grow it to 1,000. Our member information is in spreadsheets on a personal computer. Our club president has been using Yahoo to send out a newsletter. This has many problems.
I believe we need to put our list on a server in a database. We have applications beyond email for the database so I am looking for a package that will work with our database rather than limit us to their layout. Want to SQL select from mysql which people to send which newsletter or other announcement. Looks like phplist uses many-to-many instead of this approach, but that might work.
Would be nice to have already written code to handle opt-in and opt-out, scheduling, throttling, bounced mail etc.
I am generally happy with DreamHost. Only complaint so far is that although my file uploads normally are available instantly, sometimes they don't update for several hours. This high traffic on the mug server has me concerned that even with a small email list I might experience difficulties even with spacing them out.
I am a web developer not a programmer. I work in XHTML strict with external CSS and no tables for layout. Use HomeSite editor to hand code. Want to get into php/mysql.
I have looked a bulk mail service on the web. I see there phplist, mail(), and a Pear Mail package.
So, with your experience what would you recommend?