thanks for answering Where can I get the list kicker tool
I had a look on www.declude.com but didn't see it thanks Chris Chris Bone Web Engineer Chartway Federal Credit Union http://www.chartway.com This message contains information from Chartway Federal Credit Union which may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify by e-mail [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 03/29/02 08:20AM >>> >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/ 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/
