How can I export all email addresses I have sent to from Outlook or any other Email Client?

Question

I would like to export a list of email addresses of people I have previously sent mail to. I don't think there is a way to do this without an add-in.

I tried a tool called Gwabbit and it did not do what I needed.

There are some answers here based on the NK2 file and utilities that read it, but it's not the solution because the NK2 file will not always have every recipient you've ever emailed for the following reasons:

1. You can edit it (simply by deleting a suggested contact as it pops up)
2. It's unique to your profile (each login on each device, not counting roaming profiles), so if you use multiple machines/devices it doesn't get all recipients.

What I really want is to go through all the sent mail, optionally my received mail too, and harvest all the email addresses in there.

I initially wrote this question for Outlook, but if there is an app or utility that will do this outside of Outlook, it's worth migrating mail, even if just for this one time need.

Answer 1

Assuming you have Outlook 2007 :

• Click on File, Import and Export to open the Wizard
• Select Export to a File and click on Next
• Select Microsoft Excel 97-2003 (or a CSV file) and click on Next
• Select an Outlook folder and click on Next
• Click on Browse to select a location and then type the file name to export the information to (terminated by .xls) and click Next
• Click on Map Custom Fields. This will bring up a list of all the available fields that are available in that folder.
• Since we are only interested in Email address, click on Clear Map and then from the Left side click on From: (address) and drag that to the Right list
• Click on OK
• Click on Finish
• Open the output file using Excel and remove duplicates

Answer 2

There's a file called something.NK2 - this lists all of your autocomplete addresses. You can basically copy and paste the file and viola your new outlook has your old autocomplete. I'm sure that file can be read too, try googling .NK2 reader.

http://office.microsoft.com/en-us/outlook/HA011394511033.aspx

Answer 3

Okay.. this is a bit complex example, but see "access outlook stuff with perl".

And you'll need cygwin with perl.

If you know how to code it should be straight forward to adapt code from the message threat to print out email addresses in to a csv file.

ActivePerl

cygwin

Small cygwin+perl howto