email newsletter service

Hi everyone,

I'm working with a school wanting to send out their weekly Newsletter out to parents via email.

The content of newsletter (6 to 10 posts/nodes each week) will reside on the site. The email would have the title & teaser of these posts every week.

I know MailChimp can manage the email accounts and send the emails.

I can also create a VIEW with proper info (title, teaser, image).

This month, I wrote a custom module for a client, that import newsletters (or "campaigns", as MailChimp calls them) from a given MailChimp account into a Drupal site as nodes. (As many of you know, MailChimp is a rather nice third-party newsletter service.)

How it works:
- Depends on mailchimp.module, using the same account configured in mailchimp.module settings.
- Uses a custom table to store ID's of imported messages.
- Checks MailChimp account for new messages on every cron run, or when an admin pushes the big shiny "Import campaigns" button.

Attached is the code for a potential new module for email newsletters (everything has .txt appended to the filename so I can attach it). It's called SunMailer; the code is based on the module The Cornell Daily Sun currently uses to send out its email newsletter.

I'm looking for the best way to set up a email newsletter service within our Drupal site.

We currently send weekly emails to a subscriber list that exists outside our CMS (we use CommuniGate Pro: LIST Module), but it is limited to simply managing the mail list and we want to move to a system that will give us options like tracking, reports, and perhaps even integration with taxonomy, etc.