Move addresses to another mailing list.
Posted: Wed Jul 09, 2014 5:14 pm
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.
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.