How to export email addresses in MS Outlook : Import and Export progress bar

How to export email addresses from MS Outlook

ybierling February 19, 2017February 16, 2017 csv, email, en, export, extract, file, Gmail, import, LinkedIn, Microsoft, outlook, simple, useful, various

Wondering how to export all email addresses from the email database in Microsoft Outlook, in order for example to import them in Gmail, or find matches in LinkedIn ?

It is pretty simple. Start by opening the FILE menu

Microsoft Outlook FILE menu

There, in the Open & Export section, open the Import/Export menu

Microsoft Outlook Import/Export menu

Select Export to a file

Export to a file option

Then select Comma Separated Values

Comma Separated Values (CSV) export option

Here, selected one folder from where the email addresses will be retrieved – for example the Sent Items folder will contain email addresses of all recipients ever contacted with the mailbox.

Export folder selection, for example Sent Items

Select a destination folder for the output file

Export file name and folder selection

Select the Export action, and enter the Map Custom Fields menu – this in order to create a clean file containing only email addresses

Selection of actions to perform

Here, on the right side box, keep only the fields which are interesting, in this case the To and CC email addresses from the emails found in Sent Items folder

Custom fields mapping to select export fields

The Import and Export Progress will show the advancement, as the operation might take some time depending on the amount of emails

Import and Export progress bar

And that’s it ! Now, as the result file might contain a lot of unwanted characters (for example Lotus Notes domain names, registered names, …), do not hesitate to use Notepad++ how to extract email addresses from a file in order to obtain a cleaner file that you can then import in another tool

Related articles across the web