Unsubscribe People from the List

MailChimp

 

MailChimp is a cloud-based email marketing solution, that allows designing and sending marketing emails.

Update Subscriber Status to Unsubscribed

Query Text

UPDATE "ListMembers" 
 SET "Status"='Unsubscribed' 
 WHERE "ListId" IN ('c3bf41da34') and "Email" IN ('ray@gmail.com', 'john@gmail.com', 'fred@gmail.com')
  

Open Query