Who’s in Your Email Social Network?

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:

001
002
003
004
005
006
007
008
009
010
011
012
013
014
## 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

Leave a Reply