use "unique" selectorthe toggle filters form
use "unique" selector
pls post screen shotThanks. Tried the unique selector got the same results.
Here is what I did. I selected the two lists and played with the unique option and got the same results.
If you do it via sync it will change the lists. And it sounded as if you did not want that, but just email all unique subs from both lists.how do I remove a duplicate between two lists
If you do it via sync it will change the lists. And it sounded as if you did not want that, but just email all unique subs from both lists.
If you just want the result of "no dupes" then the filters form via unique and export will give you the list of unique subscribers across both lists.
You could try something in phpMyAdmin, it has triggers and routines there, but it is a bit fiddly til fully scripted.You're right about changing the list. I did a test on two lists and the other list got zeroed out. But it did delete the dupe.
I guess I just have to get into the whole exporting deal. I been trying to avoid it lol. So once I export this list. I guess im going to have to make a new list and import these unique subscribers correct? What happens if they unsubscribed at one point. Just seems like alot of work. I would rather just do it in MS Access and connecting to the Databases directly.
You could try something in phpMyAdmin, it has triggers and routines there, but it is a bit fiddly til fully scripted.
One other thing that just crossed my mind is: create a list #3, and sync #1 and afterward #2 into it, then the sync will do what you want, and without much ex/import/etc![]()