1

We use a shared Outlook directory as our helpdesk. Emails come in, we allocate an email to a specific team member using categories, and then that person responds. Once an email issue is resolved it is moved to another shared directory called Done.

My ultimate goal: Create a chart that shows

  • How many emails were received,

  • How many emails were sent, and

  • How many emails a team member sent.

I know how to create the chart using HTML/JavaScript, but I need this Outlook information in a CSV/JSON format to do this. I do not mind having to manually export data from Outlook into this format.

I do NOT need to know:

  • subject of email
  • recipients of email,
  • contents of email

What is the best solution here?

-1

Take a look at the ReliefJet Essentials for Outlook developed by my company. It provides a comprehensive set of reports that will surely let you achieve your goals. You can get all required tables and create charts in Excel.

In particular, the "Message Statistics by ..." group of reports included in the product will give you all required data for building chart.

For example, Message Statistics by Date:

... and you can easily buld any charts available in Excel:

enter image description here

|improve this answer|||||
  • Please post a screenshot of the statistics you talk about. Make sure these numbers are visible: How many emails were received, How many emails were sent, and How many emails a team member sent. – Nicolas Raoul Nov 28 '18 at 2:51
  • @NicolasRaoul done. – thims Nov 28 '18 at 18:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.