Release Mail via Database |
Post Reply 
|
| Author | |
insitec 
Newbie 
Joined: 21 April 2008 Status: Offline Points: 12 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Release Mail via DatabasePosted: 08 September 2014 at 12:43am |
|
Hi folks,
I just had a request to release any and all mail from a particular address, irrespective of to whom it was addressed. Anyone ever done that - or anything similar - before? I'm guessing I could change a flag in the database, after selecting all the emails from that address... but I'm really not sure. Any help greatly appreciated. Cheers, Andy
|
|
 |
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(1)
Quote Reply
Posted: 08 September 2014 at 9:02am |
|
Hi Andy,
You can run the following directly against the database: UPDATE tblQuarantine SET Deliver = 1 WHERE EmailFrom = 'some_user@some_domain.com' replacing the sample email address above with the actual sender's email address. Note that after sending all the emails quarantined having that email address as the sender, SpamFilter will then add entries to its internal whitelist matching that sender with any recipients for which that email was blocked. This causes any future emails from that specific sender to any of those recipients to be automatically whitelisted from that point on. If you want to see what emails will be delivered by that query before actually delivering them, you can run this query instead: SELECT * FROM tblQuarantine WHERE EmailFrom='some_user@some_domain.com' |
|
|
|
|
insitec
Newbie
Joined: 21 April 2008 Status: Offline Points: 12 |
Post Options
Thanks(0)
Quote Reply
Posted: 08 September 2014 at 8:27pm |
|
Thank you very much!
Deliver = 1 in tblQuarantine was exactly the missing piece of my puzzle! Much appreciated, Andy. |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.133 seconds.