
Outlook 2007 or earlier versions: On the File menu, select Import and Export. In the Import and Export Wizard dialog box, select Export to a file, and then select Next. In the Export to a File dialog box, select Comma Separated Values (Windows), and then select Next. In the Save exported file as box, specify the location and the name of the exported file, and then select Next.Ĭhange the name of the fax number column to OtherPhone (without the quotation marks), and then delete the original, blank OtherPhone column. If the original OtherPhone column contains information, select another column that is blank, change the name of the fax number column to the name of that column, and then delete the original column. How to import the changed data back to Outlook If you receive a prompt to keep this format when you save the changes to your data file in Excel, select Yes. How to delete duplicate contacts in outlook 2010 how to# In the Import and Export Wizard dialog box, select Import from another program or file, and then select Next. In the Import a File dialog box, select Comma Separated Values (Windows), and then select Next. In the File to import box, type the location and the name of the file that you just changed, select Replace duplicates with items imported, and then select Next. The recipients should be listed only once in the Select Names dialog box. In addition, if you use the Check Names feature when you address an e-mail message, you are forced to choose between the fax number and the e-mail address listings, even though you are sending an e-mail message.“I have many duplicated entries in my Outlook 2016 people list, can you provide me a solution to consolidate the list and get rid of any dups?” More informationĭuplicate entries double the size of the list that you need to search in order to address a message. Good question, there is a little trick to find those redundant contacts and remove or merge it.
How to delete duplicate contacts in outlook 2010 how to#.