Jump to content

Count E-Mail receivers


Recommended Posts

Dear all

I'm looking for a solution for the following problem:

I have a case with 1 Mio. Emails to/from a specific person.  Can I produce a list with all receivers and count the mails to them? It should be like a top 100 list of all correspondent addresses.

I was able to make a CSV-file with all receivers. I then imported the CSV-data to Excel and made a pivot query. This gives me the number of mails sent to a specific group of senders. E.g. I get the number of mails sent to receiver "A", and also the number of mails sent to "A & B". I am looking for a possibilty to produce a list with the number of all mails to "A" (regardless, if the mail was sent to "A" only or together with any other recipient(s)). And, I shouldn't need to specify the receiver (when I know the receiver, I get the answer quickly).

Thanks for your help!
Best regards,

Link to comment
Share on other sites

Hi Chris,

Please follow the instructions below:

1. Do Email Address facet query:
   All senders -> [person X]

   This will result in a cluster representing all emails sent by [person X].

2. Expand Email Address facet -> All receivers branch

3. Right click on All receivers branch and select Organize -> Sort by item count

4. Click 'Show only highlighted values' icon at the bottom of Email Address facet

5. The last step is to just export the results by right clicking on All receivers branch and selecting 'Export values...'


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...