[TriLUG] Mass mailing ideas

[matt at noway2.thruhere.net]

Sending passwords in an email isn't the most secure thing, but setting
aside that issue ...

It looks to me like you could export the spread sheet as a comma separated
value list.  Then use a script on Ubuntu to read the file, extract each
users email address and password and call 'sendmail' (with their email
address that was extracted) and send them a standard form with their
password put in.

I am not an expert script writer, but off hand this seems like it could be
done in a few lines of shell script with either SED or AWK.

> 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.
> --
> This message was sent to: Matt Flyer <matt at noway2.thruhere.net>
> To unsubscribe, send a blank message to trilug-leave at trilug.org from that
> address.
> TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
> Unsubscribe or edit options on the web	:
> http://www.trilug.org/mailman/options/trilug/matt%40noway2.thruhere.net
> TriLUG FAQ          :
> http://www.trilug.org/wiki/Frequently_Asked_Questions
>