|
1.
|
Open Outlook Express.
|
|
2.
|
Select File/Export/Address book. |
|
3.
|
Click Text File (Comma Separated Values) then Export. |
|
4.
|
Enter a file name (e.g. OE_Export) and browse to the folder that will contain your Contacts file.
Click Save. The export file will be saved as a .csv file type |
|
5.
|
Click Next |
|
6.
|
On the field display list, make sure First Name, Last Name and Name are checked.
Remove check marks on any fields you do not want to transfer.
If in doubt, include the fields. They can easily be removed later.
|
|
7.
|
Click Finish. Click OK. Close “Address Export Tool” window. |
|
8.
|
Open Excel. |
|
9.
|
Select File /Open... and browse to the folder where you saved your exported file |
|
10.
|
In the “Open” window, click the drop-down arrow for “Select Files of type”.
Scroll to the top of the list and select All Files *.* |
|
11.
|
Click on the saved file OE_Export.csv then click Open. |
|
12.
|
After a short wait the data will show in the Excel Worksheet.
It will look muddled but that is only because the columns are too narrow.
Drag them wider and the data will display normally. |
|
13.
|
Click File/Save as... |
|
14.
|
In the “Save As” window, enter a file name e.g. Contacts_Master. |
|
15.
|
Click on the drop-down arrow for "Select Files of type".
Scroll to the top of the list and select "Microsoft Excel Workbook (.xls)" |
|
16.
|
Click Save. |
|
17.
|
The Title Bar should now read "Contacts_Master.xls". Click File/Menu/Save. |
|
18.
|
Congratulations. You now have an Excel Database. |
