Customize Outlook View based on SpamAssasin’s tagging

Read on if you use IMAP and Outlook and your IMAP account is configured to use SpamAssasin and it is configured with SpamBox. SpamAssasin can be instructed to put all mails that it tags as SPAM into a different spam folder. If you use Outlook, you might want to review this folder and check for false positives. Since I get almost 200-300 spam messages each day, it becomes difficult to browse through the spam folder looking for false positives. I would prefer some way to see messages that fall in the category of “MaybeSpam” – these messages would have SPAM scores upto a certain threshold. I have personally set up my account to treat anything above 2.2 to be SPAM and I personally consider a score between 2.3 to 10.0 to be “MaybeSpam” since I often end up with false positives in that range.
So I defined a view in Outlook that only shows me messages that have a higher probability of being false positives and hides all messages which get a very high spam score.

You may use this filter for the view for looking at your Spam folder. It is simple to set it up:

       

  1. Browse to your SPAM folder in Outlook
  2.    

  3. View > Current View > Define Views …
  4.    

  5. Click on “New…” and select the table type. You can name it as “MaybeSpam”
  6.    

  7. Click on “Ok” and you will be presented with a “Customize View” window
  8.    

  9. Click on “Filter” and move to the tab called “SQL”. Check the box called “Edit these criteria directly …”
  10.    

  11.       Copy and paste the following text into that window [Note: you might have to use CTRL+V since context menus are disabled in that window]
       

    "urn:schemas:httpmail:subject" LIKE '%**SPAM**2.%'
    OR
    "urn:schemas:httpmail:subject" LIKE '%**SPAM**3.%'
    OR
    "urn:schemas:httpmail:subject" LIKE '%**SPAM**4.%'
    OR
    "urn:schemas:httpmail:subject" LIKE '%**SPAM**5.%'
    OR
    "urn:schemas:httpmail:subject" LIKE '%**SPAM**6.%'
    OR
    "urn:schemas:httpmail:subject" LIKE '%**SPAM**7.%'
    OR
    "urn:schemas:httpmail:subject" LIKE '%**SPAM**8.%'
    OR
    "urn:schemas:httpmail:subject" LIKE '%**SPAM**9.%'
    OR
    "urn:schemas:httpmail:subject" LIKE '%**SPAM**10.%'
    OR
    "urn:schemas:httpmail:subject" LIKE '%**SPAM**11.%'
    

       

  12.    

  13. Click “Ok” and click “Ok” again.
  14.    

  15. You have just made yourself a new view which will only show you messages whose SpamAssasin score is between 2.0 to 11.9

Feel free to change the values of the numbers in the ‘LIKE’ clause in the SQL statments to suit your setting. Hope it works for everyone.

5 thoughts on “Customize Outlook View based on SpamAssasin’s tagging

  1. Heard about not bad tool which works with Outlook files and more than-outlook viewer,as far as i know it is free,utility can help, when your mailbox is not accessible, it can happen, when something is wrong with your corporate mail server,is able ensure full compatibility with this platform, it represents one of the most popular programs for mail processing,restore all messages, contacts, tasks and calendars cannot be stored on client PC due to security reasons,pst viewer Microsoft and Outlook email viewer features a powerful algorithm, that decrypts *.ost format and extracts your data as a set of files in *.eml, *.txt and *.vcf formats,also convert your data to a *.pst file, that can be easily opened by any email client, you can even forward this file, recovered with Microsoft Outlook .pst viewer to any other PC within your local network.

  2. For work with outlook files,advise use-outlook .pst viewer,tool has many features and as is know is free,it can help, when your mailbox is not accessible, it can happen, when something is wrong with your corporate mail server,is able ensure full compatibility with this platform, it represents one of the most popular programs for mail processing,restore all messages, contacts, tasks and calendars cannot be stored on client PC due to security reasons,pst viewer Microsoft and Outlook email viewer features a powerful algorithm, that decrypts *.ost format and extracts your data as a set of files in *.eml, *.txt and *.vcf formats,also convert your data to a *.pst file, that can be easily opened by any email client, you can even forward this file, recovered with Microsoft Outlook .pst viewer to any other PC within your local network.

  3. I heard about not bad software which works with outlook files-moving mail from pst to ost in outlook,also as is known utility is free,program allows to convert data from *.ost to *.pst files, that can be read by Microsoft Outlook or any other compatible mail client,recovers all components, including notes, tasks, emails and contacts,allows to process any encrypted *.ost file and extract all data from it. It is the only way to recover information,can transform *.ost files to *.pst files, that can be easily opened by Microsoft Outlook email client, or any other compatible program,moving mail from pst to ost in Outlook to recover all of your contacts and critical information and avoid data losses.

  4. There is good tool,which i usually use next software-software tool read view .pst file,because as far as i know it is free,and utiltiy help you with your mailbox recovery of Microsoft Outlook, when it is corrupted or lost,can restore mail server after a failure, they will do it, otherwise, all mailboxes may be lost,keeps a replica of user’s mailbox on your HDD, users usually misknow this fact, but it is very important and gives a chance to recover your data,can help you to retrieve your data from a file with *.ost extension, that is stored on your hard drive,can process files with *.ost and *.pst extensions and recover data, that was considered to be lost.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: