ttp-news mailing list

Every month, we prepare an e-mail newsletter and mail it to ~9,000 subscribers.

The mailing list is kept in ACEware, but we use the campus GNU Mailman list manager to send the newsletter.

Every month, then, we need to move the mailing list from ACE to Mailman.

For future reference, here's what I did today:

1. Clean the list in a text editor (I used BBEdit)
zap "
replace , and ; with \r
look for illegal characters: [^a-zA-Z0-9\r.@_'-]
this also finds a pair of email addresses separated by a space and one by " or "
lowercase
sort
dedupe (184)

2. Manage mailing list
https://calmail.berkeley.edu/manage/list/mylists
log in as ttplists
choose ttp-news
choose Advanced
choose Bulk Remove
choose Remove all current subscribers (at bottom)
Submit
Now we're limited to adding 5,000 addresses at a time, so I cut 'n' paste into the web form instead of uploading a file
I get a proxy error every time, but when I check it has uploaded OK