User Tools

Site Tools


reference:delete_list_member_from_all_lists
no way to compare when less than two revisions

Differences

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, 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 by 127.0.0.1