Who's in Your Email Social Network?

Thu, Aug 29, 2013 One-minute read

Have you ever wondered who’s in your “Email Social Network”?

I was wondering the other day how to find out who I mail the most. With a bit of PowerShell scripting, the answer is a breeze to find out:

## Connect with Outlook, and open the 'Sent Items'
$olApp = New-Object -com Outlook.Application 
$namespace = $olApp.GetNamespace("MAPI")
$sentItems = $namespace.GetDefaultFolder(5)
## Go through each item, split out names when there were multiple
## recipients, and clean them up a bit
$sentEverTo = $sentItems.Items | % { $_.To -split ";" } | % { $_.Trim(" '") }

## Group by how often you've sent mail to them
$sortedTo = $sentEverTo | group

## Explore
$sortedTo | sort Count