This shows you the differences between two versions of the page.
Previous revision | |||
— | reference:delete_list_member_from_all_lists [2018/11/14 10:45] (current) โ external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ======Delete list member from all lists====== | ||
+ | You can delete an email address from all VPOP3 distribution & mailing lists. | ||
+ | Go to Settings โ Database โ Query | ||
+ | |||
+ | Alternatively, | ||
+ | |||
+ | psql | ||
+ | (The password is ' | ||
+ | |||
+ | Then, type | ||
+ | |||
+ | < | ||
+ | DELETE FROM users.listmembers WHERE LOWER(address)='< | ||
+ | </ | ||
+ | |||
+ | Replace <email address in lower case> with the full email address in lower case. | ||
+ | |||
+ | N.B. VPOP3 does not need to be stopped while you do this |