[TriLUG] Mass mailing ideas
dave at jamsoft.com
Tue Jan 18 17:12:01 EST 2011
If the OP runs an email infrastructure, I'm going to assume he already understands the ramifications of sending passwords this way.
Export the spreadsheet as CSV to sheet.csv and run the below. Put whatever text you want between the EOFs.
cat sheet.csv | while read EMAIL NEWPASS; do
mailx -s "New password" "$EMAIL" << EOF
Hi there, your new password is $NEWPASS
Please make a note of it.
Your affectionate sysadmin
----- Original Message -----
> 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?
> so, what tool(s) did you use?
A wise and frugal government, ... which shall leave men free to regulate their own pursuits of industry and improvement, and shall not take from the mouth of labor the bread it has earned - this is the sum of good government. - Thomas Jefferson, First Inaugural Address, March 4, 1801.
More information about the TriLUG