Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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.


Posted on Mar 25, 2020 7:30 AM

Reply
1 reply

Extracting recent email address from Mail.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.