Knowledge Base » Documentation MailCleaner »
Newsletter marked with "?Spam" tag
MailCleaner Support
Added over 2 years ago
There is no unique tag for newsletters, so if you don't want the {spam?} tag you need to set newsletters to be desired.
You can check the user's preferences with the command:
select user.username, allow_newsletters from user_pref join user on user_pref.id=user.pref where allow_newsletters = 0;
After that, if you want to change the preferences concerning newsletters, you can set for all users to be desired with the command:
update user_pref set allow_newsletters = 1;
If you want it only for users of one domain it requires two more complex commands:
update user_pref join email on user_pref.id=email.pref set allow_newsletters = 1 where email.addres like '%@domain_name';
update user_pref join user on user_pref.id=user.pref set allow_newsletters = 1 where user.domain = 'domain_name';