Exchange Email: How to move your personal address book to your Exchange account?

1. Log into HKUST WebMail at https://sqmail.ust.hk/.
2. Select Addresses.
   
3. Scroll to the bottom section Address book export and click Export to CSV File (Comma Separated Values File).
   
4. Select the option Save as and Save the file, say on your Desktop.

1. Launch Thunderbird.
   
2. Select Address Book under the Tools menu.
3. Select Export... under the Address Book's Tools menu.
4. Give a name for the file to be saved, say "my-address-book".
   
5. Under Save as type:, select the Comma Separated option.
6. Save the file, say on your Desktop.
   

1. Click the File tab.
2. Click Open.
3. Click Import.
4. Click Import from another program or file, and then click Next.
5. Under Select the file type to import, click the file type of file you want to import, and then click Next.
   The most common is Comma Separated Values (Windows), also known as a CSV file. If you are importing contacts that were exported from Outlook to an Outlook Data File (.pst), click Outlook Data File (.pst).
6. Under File to import, click Browse, select the file that you want to import, and then click OK.
7. In the Import a File dialog box, under Options, click one of the following:
   
   • Replace duplicates with items imported If an Outlook contact already exists, it is replaced by the information that you are importing.
   • Allow duplicates to be created If an Outlook contact exists, the imported contact is created as a second contact.
   • Do not import duplicate items If an Outlook contact exists, the information for the imported contact is not imported.
8. Click Next.
9. In the Import a File dialog box, under Select destination folder, click a folder for the imported contacts, and then click Next.
   This usually is the Contacts folder unless you have multiple accounts, or have created multiple contact folders for an account.
10. Click Map Custom Fields... to perform the required field mapping if necessary.
    
11. Click Finish.

Notes for Address Book with Chinese characters:

For Thunderbird users whose address book contains Chinese characters, you might try the following:

1. Configure your Language for non-Unicode programs setting from Control Panel -> the Regional and Language Options, e.g. Traditional Chinese.
2. Export Thunderbird address book in Comma Separated (*.CVS) format.
3. Open the exported file with Notepad and then save a new copy in UTF-8 format.
1. Click File and then Save As...
2. Change the Encoding to UTF-8 and then click Save.
4. Open the UTF8 format file using Excel. Adjust the field mapping by replacing the first row of your file with the 2^nd row of the Excel file in this page. The first row of the Excel file in the page are the address fields used by Thunderbird 3.x and the second row are their corresponding fields (suggestion only) to be used by Outlook.
5. Define the range (press CTRL-A and then give an arbitrary name for the range: Insert -> Name -> Define) and save it if you are using Excel 2003. If you are using Excel 2010, define the range (CTRL-A and then Formulas ->Define Name) and save it in Excel 97 - 2003 format.
6. Import the Excel 97 - 2003 format file to Outlook 2010 by mapping the relevant fields.
1. Click File -> Open -> Import.
2. Click Next to Import from another program or file.
3. Select the Microsoft Excel 97 - 2003 file format and click Next.
4. Browse to the Excel file to be imported and select Do not import Duplicate items, click Next to continue.
5. Select Contacts as the destination folder, click Next to continue.
6. Click Map Custom fields... and adjust the fields if necessary.
7. Click Finish to perform the import.

Attachments (1)

• thunderbird_outlok_field_mapping.xlsx ( 708 Views, 9.36 KB )