[TriLUG] Mass mailing ideas

[David Black]

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.

#!/bin/bash
IFS=','
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.

Sincerely,
Your affectionate sysadmin
EOF
done

Dave

----- 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?
> If
> 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.