Here is an example how to export your Microsoft office contacts into an CSV file. In Microsoft office go to: File - Open & Export - Import/Export - Export to a file Comma Separated Values Select your contacts folder Select your destination folder Map Customer Fields Adjust on the right side the To: field to have the following fields and using the same sequence. - Last name
- First Name
- Business Phone
- Business Phone 2
- Mobile Phone
- Car Phone
- Home Phone
- Home Phone 2
Press Finish to generate the CSV file Open de Gigaset excel file and via CTRL+l select the above CSV file, all contacts are visible in the excel file. The Macro will remove special characters and changes the numbers to numbers the Gigaset phone understands. The Macro (CTRL + w) generates the phonebook.xml file and stored in the same folder as the excel file is stored. |