Extracting recent email address from Mail.

Lots of people are looking for ways to extract recent email addresses from Mail. I have found a way through a search, thanks to Barney-15E out of Florida.

Simply open a terminal window and past this at the prompt:

sqlite3 ~/Library/Containers/com.apple.corerecents.recentsd/Data/Library/Recents/Recents

.mode csv

SELECT DISTINCT c.display_name, c.address

FROM contacts c INNER JOIN recents r

ON c.recent_id = r.ROWID

WHERE c.kind = 'email'

ORDER BY r.last_date DESC;

Just remember to hit return after pasting this and there is your list of recent email addresses.