As these are internal addresses of Exchange and these people are part of your Global Address Book, we can filter them out in the following way.Īs the condition type: Press OK to apply the filter. If you are using an Exchange account, then you’ll also see some addresses in the x500 format. Press OK to start the duplicate removal process.On the Data tab click: Remove Duplicates.If it opened with everything in a single column, use the Data-> Text to Columns feature to get the 2 fields in separate columns. This is a very easy task we can perform in Excel. Step 2: Remove duplicatesĪs you've most likely received multiple emails from the some senders, we’ll remove the duplicates. Make sure you only export the “From: (Name)” and “From: (Address)” fields. Press OK and then Finish to start the export process.

Drag and drop the following fields to the “To:” box on the right.

In the “Map Custom Fields” dialog press: Clear Map.

If not selected yet, select the checkbox in front of: Export “E-Mail messages” from folder: Inbox.

Select a folder location and name for your csv-file.

Verify that the correct folder is selected.

Select the folder you wish to use as the source.

See the section below Step 5 when you want to use the Sent Items folder as a source.

In this example, we’ll use the Inbox folder as a source but you can use any other mail folder as well. Step 1: Export “From Name” and “From Address” to a csv-file Two of them are listed at the bottom of this guide. The 5 steps below describe the entire process which in reality only takes a few minutes to complete (it sure took longer to write them down).Īs an alternative, to fully automate it and also to prevent you forget to add people as contacts in the future, you can use an add-in instead as well. Unfortunately, there is no native option in Outlook for this, but with some clever use of the “Import and Export Wizard” and Excel, we can most definitely speed up the process and have full control over who will get added as a contact. It there a quicker way to review the senders and recipients and add them to my Contacts folder without creating a massive amount of duplicate contacts? This is of course a really slow process and I think I've learned my lesson by now. I'm now going through my Inbox and Sent Items folder and right click on a sender or recipient and choose: Add to Outlook Contacts Sadly, due to an oversight when migrating my Outlook data from one computer to the other, my AutoComplete cache was lost and since I never added people as a Contact, my Contacts folder is heavily outdated.

Glexsoft outlook import wizard