Jump to content

How to batch unsubscribe certain members from newsletter

Featured Replies

Posted

I have certain set of moderators, admins, and users that I wish to batch unsubscribe from newsletter option. They all are using same domain email ID. Can I unsubscribe them from sql quickly? Thanks.

Make sure you add in your table prefix and replace email domain with actual domain:

UPDATE core_members SET allow_admin_mails = 0 WHERE email LIKE '%@domain.com';

  • Author

Thanks Jim, perfect solution. Just changed core_members to members table.

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.