The recipients should be listed only once in the Select Names dialog box. 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. In the Import a File dialog box, select Comma Separated Values (Windows), and then select Next. In the Import and Export Wizard dialog box, select Import from another program or file, and then select Next.
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.
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. 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. In the Export to a File dialog box, select Comma Separated Values (Windows), and then select Next. In the Import and Export Wizard dialog box, select Export to a file, and then select Next. Outlook 2007 or earlier versions: On the File menu, select Import and Export.Outlook 2010: On the File tab, select Open, and then select Import.Outlook 2013 or later versions: On the File tab, select Open & Export, and then select Import/Export.To do this, follow the steps for your version of Outlook. Open the Import and Export Wizard in Outlook. How to export the current Contacts folder Import the changed data back to Outlook.Edit the exported data file in Microsoft Excel.Export the current Contacts folder to a.Use the following methods to globally move fax numbers from one field to another: If you have already stored fax telephone numbers in a fax telephone number field, you can work around this behavior by globally moving the fax numbers from the current field to another field that is not related to faxing.īack up the Contacts folder or make a copy of the exported file before you make any changes, or import them back to Outlook, to avoid accidentally losing any contacts in the process. This way, the fax number is still available, but it is not considered an alternative method for delivery by Outlook or by the Check Names feature. For example, you can store fax numbers in the Other field in the telephone numbers section of the name-Contact dialog box. If you are not using Outlook to send faxes, you can avoid this behavior by storing fax numbers in a field that is not specific to faxing. Recipients who have both an e-mail address and a fax number are listed two times one time for the e-mail address and one time for the fax number. This behavior is by design in the Outlook Address Book. One listing has an e-mail appended to the address, and the second listing has a fax appended to the address. When you open the Address Book in Microsoft Outlook, and then select Contacts, some recipient addresses are listed two times.