Solved

Email count management dashboard

Posted on 2011-02-10
3
549 Views
Last Modified: 2012-05-11
A sales manager wants to include in his management dashboard the number of emails sent and received and the number of contact items added by his sales people. He also wants the phone call count, but that's another matter.

I don't think there's anything off the shelf that'll accomplish this in an Exchange/Outlook environment. I'd greatly appreciate any comments and URLs to any tools or scripts that may be purchased to see how close I can come to meeting his requirements.
0
Comment
Question by:cwest1
  • 2
3 Comments
 
LVL 4

Expert Comment

by:shieldmanagement
ID: 34864042
The easiest way is to copy the logs  of all sent/received emails for those sales people into a excel spreadsheet and use a count formula.  Of course you'll need to do this everytime he wants it.
0
 

Accepted Solution

by:
cwest1 earned 0 total points
ID: 34883830
Disappointing not to get any meaningful answers. This is what I'm now doing. I used SilentMail to automate copies of sent messages being sent to an smtp server, and a parser to grab the emails from drop folders as they arrive and insert records into MSSQL. Now I'll write a .NET web app to select and display.
0
 

Author Closing Comment

by:cwest1
ID: 34924240
SOlved the issue myself.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
Find out what you should include to make the best professional email signature for your organization.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

776 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