Mass mailing with Zimbra

My office mass mail regularly using PHPList. Off course this means there´s a MySQL database which is used by PHPList to, among other things, store contacts information.
Also we have a server serving Zimba Network Edition, with several accounts each one with its set of contacts.

So, we have a problem here, which is, we have basically two sets of contacts, the ones stored in Zimbra, and the ones stored in MySQL PHPlist´s database.

We would like to have an unique contact database, easy to manage from Outlook or Zimbra web interface, and we would also like to retain the ability to mass mail some of our contacts.

Off course, we have the approval of our customers to send those mails, we don´t spam.

So… Can this be done with Zimbra? Can we replace PHPList with Zimbra? or at least can we make PHPList use zimbra´s contacts? is there a proposed solution for this? Your help would be very much appreciated.

——————–

I’m not sure what the tables are called, but why couldn’t you just write a stored procedure in mysql, automate it via cron and have that stored procedure copy your zimbra contacts into your phplist database nightly/hourly/etc… you can transform data in any way you may need and it’s automated with no changes to zimbra or to phplist…

just a thought….

__________________
1st time Zimbra Administrator

Release 6.0.2_GA_1912.RHEL5_64_20091020145322 RHEL5_64 NETWORK edition.

RHEL 5.3 – After complete and utter Ubuntu 8.0.4 failure.

Hardware Information:
AMD Dual Core 2216 x2
16GB of RAM
425 GB (6 disks) of RAID 10 storage
3ware + Seagate SATAs

Leave a Reply

Your email address will not be published. Required fields are marked *

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Anti-spam image