First of all, let me explain the scenario:
We are setting a newsletter here in my work, so we set a database
with users information, html, etc (using Sql-Server 7.0 and Windows NT
4.0), and we make administrators via web too, using ASP. We will have a
lot of types of newsletter, acording user age, location, etc., he will
receive a different newsletter.
All this is working fine, and now we desire to send this emails
quickly (QmAiL!!), and I was wondering how to integrate this application
with qmail. My first ideia was to use ezmlm with suport to sql database,
but how ezmlm cant connect to a SQL-Server, I decided to use a perl
script (and perl module FreeTDS), to make queries to the sql database,
insert into my local mysql database and then let ezmlm do the hard work
for us.
First, is there a better aproach? (I cant find). I would like to use
ezmlm, because I think it will deliver the emails the most quickly
possible. Second, how we will have a lot of kinds of newsletters, will
I have to construct one diferent maillist to each diferent newsletter?
They cant share the same tables....
I hope I was clear, sorry about my English...
--
Failure is not an option. It comes bundled with your Microsoft product.
