Move addresses to another mailing list.

Use this forum for questions regarding adoption and functionality of OpenEMM

Moderator: moderator

timr
Posts: 35
Joined: Mon Aug 31, 2009 2:31 pm

Move addresses to another mailing list.

Post by timr »

I need to move some email addresses to another mailing list. I've looked at the database schema and it looks like all I have to do is update the mailing list id in customer_1_binding_tbl.
This is what I'm trying to do.

Email addresses on Mailing list named A (mailing list id =1)
Move the addresses to Mailing list named B (mailing list id=2)

UPDATE customer_1_binding_tbl set mailinglist_id=2 where mailinglist_id=1

I think the above will work but thought I would double check with other OpenEMM users.
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Move addresses to another mailing list.

Post by maschoff »

The OpenEMM DB schema is explained in detail in the OpenEMM Extension Development Guide. And you should not only take care of the mailinglist binding but also of its user status (0 = active, etc.).
OpenEMM Maintainer
Post Reply