User Tools

Site Tools


reference:delete_list_member_from_all_lists

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

reference:delete_list_member_from_all_lists [2018/11/14 10:45] (current)
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,​ at a command prompt in the VPOP3 directory run
 +
 +  psql
 +(The password is '​vpop3pass'​)
 +
 +Then, type
 +
 +<​code>​
 +DELETE FROM users.listmembers WHERE LOWER(address)='<​email address in lower case>';​
 +</​code>​
 +
 +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
reference/delete_list_member_from_all_lists.txt · Last modified: 2018/11/14 10:45 (external edit)