We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Extract Header Data For Display In Column

Psychotext
Psychotext asked
on
Medium Priority
701 Views
Last Modified: 2012-08-13
I have recently installed a spam filter for outlook, which adds a field "x-spam-level" to the headers of all email messages.  I want to be able to display this as a column in my mail views, but I'm not sure how to do it.  I've found the formula window for new fields, but I dont know the right syntax to pull the item out of the header.  A quick description of what to do would be appreciated.

Thanks in advance.
Comment
Watch Question

Karen FalandaysTraining Specialist
CERTIFIED EXPERT

Commented:
Right mouse click on the headers in the view and choose "field chooser" . In here, make sure you can see "user defined fields". When the column heading is visible, Drag with left mouse up to the columns and let go

Let me know
K

Author

Commented:
I know that bit, but I actually need to add it as a "user defined field".  My problem is that I don't know the syntax to pull the data out of the header.
Karen FalandaysTraining Specialist
CERTIFIED EXPERT

Commented:
Wait, I thought your spam filter already added this field? Is it listed under ANY of the categories?

Author

Commented:
No, all the spam filter does is check the mail before it gets to Outlook and adds certain fields / text into the message header.  I am looking for a way to pull this information out.  There is nothing in any of the categories that brings back this data (Trust me, I've tried every field!).
Karen FalandaysTraining Specialist
CERTIFIED EXPERT

Commented:
Sorry, don't know. I'm curious in the field chooser: If you clidk on the "NEW" button here and add it to user defined, does it show the correct info? What is the spam filter program?

This is a good one!
K

Author

Commented:
I just get a blank column if I do that.  I assume I have to type some sort of formula in to pull the data out, but I can't seem to find much useful information on the net about it.

The spam filter is SAProxy (www.saproxy.com).
Karen FalandaysTraining Specialist
CERTIFIED EXPERT

Commented:
I'll keep checking
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Yeah, that's how the headers come out.

Is Outlook really so backward that I can't use some code to pull the data out of the header?  Jeez, surely there must be some code to expose the header object so that I can pull a substring out of it?  I might try spambayes, but I would be very dissapointed to find that Outlook was so basic in this respect.
CERTIFIED EXPERT

Commented:
I am afraid yes.
you might try to use a mix of Redmption and OutlookSpy
Redemption: http://www.dimastr.com/redemption/
OutlookSpy: http://www.dimastr.com/outspy/

About spambayes, it is really a must have....

Stefri

Author

Commented:
People give Lotus Notes a lot of stick, but I'd never have this sort of problem with it.  As for SpamBayes, you really seem sold on its quality - I shall try it out for a few days.
CERTIFIED EXPERT

Commented:
It has the ability to clean more than one mailbox at a time, convenient when you have shared mailboxes.

It cleans your own maibox and the other ones you have in your profile

Stefri

Author

Commented:
Thanks for your help.  I do like the Outlook integration, but one thing it's unfortunately missing is that it doesn't wrap the spam emails, meaning that embedded tracking, viruses etc can still be activated.
CERTIFIED EXPERT

Commented:
Do not open them
Use spam Bayes show spam clues
stefri
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.