Chris, If you can write Perl programs then I'd suggest the Mail::Bulkmail package by James A Thomason III. It is available from CPAN and ActiveState's repository. It can receive data from a function which can be a query.
It is very fast but it also has a provision for envelope sending where an envelope is sent with a specified number of recipients and one message per envelope. Envelope sending is really fast. But you have to make certain you sort your list by domain. MSN and Hotmail both reject envelope sending but almost all the other big domains including aol and yahoo accept them. It drastically reduces bandwidth from your server so it is worthwhile treating msn and hotmail differently. You can set an envelope limit. It does require an MTA. In my opinion the Microsoft SMTP server works exceedingly well for this. I would personally not want to use my IMAIL server. Terry Fritts Friday, March 29, 2002 you wrote: CB> I appreciate any help I can get here.... CB> I have a need to send an email to certain members (credit union) every month CB> I can generate an SQL Server query to pull email addresses etc CB> My question is this.... CB> How can I get my SQL server email addresses into a format that I can use as a mailing list? CB> This list will need to be regenerated before every mailing, as my members will be modifying CB> their preferences through web screens into the SQL server CB> Say I get 20,000 signed up.... I assume that IMail can handle that? CB> thanks in advance for any pointers Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit the Knowledge Base for answers to frequently asked questions: http://www.ipswitch.com/support/IMail/
