@juan jimenez
Export contact data
You can export your address book to Excel as follows:
Open the Contacts module.
In Outlook select the command File → Import / Export. In Outlook, go to File → Open → Import.
Select Export to File and click Next.
Select Microsoft Excel as the file type and click Next.
Select Contacts and click Next.
Specify where and under what name the Excel file should be saved and click Next.
Click Map Fields. Check whether the fields from Outlook are correctly mapped to the fields in the Excel table. The assignments usually match. If not, simply drag one of the fields from the left window into the corresponding field in the right window. When you are finished, close the dialog with OK.
Click on Finish to generate the Excel file.
Edit data with Excel
Open the contact information file in Excel. Typical inconsistencies, assignment errors and different spellings can be quickly identified in the table.
Once you are done editing, save the Excel file and close it.
Import contacts again
Export the changed Excel file
Call the command File → Import / Export in Outlook or File → Open → Import.
Select Import from other programs or files and click Next.
Select Microsoft Excel as the file type and click Next.
Select the Excel file. Under Options, select Replace duplicates with imported items.
Then click on Next.
Select Contacts as the destination folder and then click Next.
Click Finish to import the data.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
