>How can I get my SQL server email addresses into a format that I can use >as a mailing list?
the mailing format is dead simple and plain text Can't DTS or export query results to a file? If the export isn't exactly in the format you want, then you could use a scriptable editor or the Unix text processing tools for Win32 http://unxutils.sourceforge.net/ to reformat the SQL output into the correct format. sed, awk, tr, etc. >This list will need to be regenerated before every mailing, as my members >will be modifying their preferences through web screens into the SQL server > >Say I get 20,000 signed up.... I assume that IMail can handle that? sometimes it will, sometimes it won't. I would suggest a real list server, or at least Scott's queue kicker tool to keep the messages moving. 20K isn't very many, it should take 30 or 40 minutes or so to send. Len http://MenAndMice.com/DNS-training http://BIND8NT.MEIway.com : ISC BIND for NT4 & W2K http://IMGate.MEIway.com : Build free, hi-perf, anti-abuse mail gateways 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/
