Home » Questions » Computers [ Ask a new question ]

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

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

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.

Asked by: Guest | Views: 96
Total answers/comments: 2
Guest [Entry]

"Basically you can use the Outlook Import/Export function to achieve this. It's typically used to migrate the actual emails, but it suits the purpose of getting just the email addresses (or any other value for that matter).

Here is how to do it in Outlook (version 2007):

Click on 'File', 'Import and Export' to open the Wizard
Select 'Export to a File' [then click Next]
Select 'Microsoft Excel 97-2003' or a CSV file [click Next]
Select an Outlook folder [Next]
Click on Browse to select a location and then type the file name
to export the information to (terminated by .xls) [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 OK
Click Finish
Open the output file using Excel and remove duplicates"
Guest [Entry]

"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"