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.
Move addresses to another mailing list.
Moderator: moderator
-
- Site Admin
- Posts: 2628
- Joined: Thu Aug 03, 2006 10:20 am
- Location: Munich, Germany
- Contact:
Re: Move addresses to another mailing list.
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