Count emails by specific subject and display count in Sharepoint

Posted on 2010-01-08
Last Modified: 2013-11-29
Hello good people,

1. I'd like to automatically count the number of emails received in a specific account, with a specific subject, on a basic pop3 email server (

2. I'd like to present the count in a Sharepoint page web part (not looking to change the dna of SP with deep, deep, "look at what I can change on Sharepoint!" code work--so it will never upgrade ;) A simple web part would be nice.

2.a. Cumulative count since a specific date (I.e. Jan 1),

2.b. Current day count

2.c. Yesterday count

Question by:celler_wellbridge

    Author Comment

    Update: I'm very open to the idea of building these counts in an aspx .NET 2.0 page and pulling it in as an iframe web part!
    LVL 51

    Accepted Solution

    To be honest, these are the type of questions most experts avoid.  It's not a specific question and is very open ended with a lot of potential issues.

    In this case I'll provide some advice and won't be able to provide a specific solution.

    #1 I have no knowledge of that product and it might not be possible.  It may or may not track those details.  Many mail programs don't do much tracking by default to minimize the overhead.  An email server is like a post office wear they don't deliver.  Email is always pushed to email servers where an email client can then connect and pull the email onto the client.  So, adding overhead like inspecting the mail and counting it is optional.  You'll have ask a specific question in another zone about how to gather metrics with squirrel mail or contact the vendor.  Ideally you'll need to push those metrics into a SQL database.

    #2 There are a LOT of choices for displaying metrics in Sharepoint assuming you get the core data into a SQL DB.  If you have the Enterprise version of MOSS you could do this with a Business Data Catalog or even an Excel Spreadsheet managed by Excel Services to show the data on a web page

    If you have SQL Reporting services you could produce reports shown in a Page Viewer Web Part in Sharepoint

    I manage very experienced Sharepoint developers that could build a custom web part to show the metrics in less than one day.  However, they've already finished the learning curve for Sharepoint

    You could use Sharepoint Designer to build a Data View Web Part to display the data

    Regarding your last comment yes many people try to do it the easy way and stick with what the know however, the problem is that then you lose all the benefits of Sharepoint.  The Page Viewer Web Part is basically an IFRAME, however, you lose security features, search can provide as many advanced choices for the data because it's not in a Sharepoint UI format and the graphics won't automatically match the Sharepoint them.

    Learn how to do it properly in Sharepoint with a custom web part.  Sharepoint is VERY popular in the Enterprise and companies get advice from experts like me when they hire employees or contractors and we can tell when a developer knows Sharepoint or simply knows how to get by with it.  Career wise being a quality Sharepoint developer is going to be worth it for a long time.

    Author Comment

    Thank you tedbilly!

    I'll seriously consider your recommendations.

    I thought I could cobble together som sort of inbox for a specific account, CC the specific emails into that client account, run a count on that box and display it in the page.

    I'm going to break down all the steps and Identify them, determine all the practical ways each step can be accomplished, then go after the best route for my needs.

    Thank you again for the thoughts and clarity.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Hello Friends, My friends and relatives always ask me how to delete all the various types of emails at once in our g-mail  or windows live account.  So I researched this topic to find a unique solution to this query.  Here it is for those who do …
    I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now