[TriLUG] Mass mailing ideas

[Justis Peters]

On 01/18/2011 04:50 PM, Douglas Ward wrote:
> We are in the process of migrating 1300+ e-mail accounts from one system to
> another.  As part of this process I must take a spreadsheet with 1300+
> e-mail addresses and new passwords, insert the information into a form
> message and send it out to every account.  Has anyone done this before?  If
> so, what tool(s) did you use?  I prefer a tool that I can run on my Ubuntu
> workstation but will consider practically anything.  Since this need will
> expire once the migration is complete I'm not really looking for any
> commercial software (although I will pay for brief usage if the service is
> compelling).  Any advice would be most helpful and appreciated.
Choose a scripting language with CSV support, export the spreadsheet to 
CSV, iterate over each row, construct the text of the email, and send it 
out using either a mailer library within the language or a command line 
tool like "nail".

Kind regards,
Justis