Microsoft KB Archive/256852

= OL2000: (IMO) How to Export Your Personal Address Book to a Text File =

Article ID: 256852

Article Last Modified on 10/8/2003

-

APPLIES TO


 * Microsoft Outlook 2000 Standard Edition

-



This article was previously published under Q256852



NOTE: These procedures only apply if you have installed Outlook with the Internet Mail Only option. To determine your installation type, click About Microsoft Outlook on the Help menu. If you have the Internet Mail Only option installed, you see "Internet Mail Only".

For information about the differences between Microsoft Outlook and Microsoft Outlook Express e-mail clients, click the following article number to view the article in the Microsoft Knowledge Base:

257824 OL2000: Differences Between Outlook and Outlook Express



SYMPTOMS
When you use Outlook, you are not able to export your Personal Address Book as a Comma Separated Values (.csv) text file.



CAUSE
Outlook does not include a utility that can export your Personal Address Book directly from a Personal Address Book file.



WORKAROUND
It is possible to import your Personal Address Book from a Contacts folder. This allows you to export your Personal Address Book directly to a .csv text file.

Use the following methods to import your Personal Address Book from a Contacts folder, and then to export your Personal Address Book to a .csv text file.

How to Create a Folder That Contains Contact Items
If you do not want to mix the contacts in your Personal Address Book file with your current Contacts folder, you must create a new folder:
 * 1) Start Outlook.
 * 2) On the View menu, make sure that Folder List is selected.
 * 3) On the File menu, point to New, and then click Folder.
 * 4) In the Create New Folder dialog box, type a name for the folder in the Name box.

NOTE: Make sure that Contact items is selected in the Folder Contains list.
 * 1) If you use multiple personal folder files or multiple Microsoft Exchange Server mailboxes, you may need to click Mailbox/Personal Folder in the Folder Contains list to create a folder in the Select where to place the folder list.

Import the Personal Address Book into Outlook Contacts

 * 1) On the File menu, click Import and Export.
 * 2) In the Import/Export Wizard, click Import from another program or file, and then click Next.
 * 3) In the Import a file dialog box, click Personal Address Book, and then click Next.
 * 4) In the next Import a File dialog box, under Select a destination, browse through the folders to the new folder that you created, and then click Next.
 * 5) Click to select the The following actions will be performed check box, and then click Finish.

You Personal Address Book is now imported.

Export Your Contacts Folder to a .csv Text File

 * 1) On the File menu, click Import and Export.
 * 2) In the Import/Export Wizard, click Export to a file, and then click Next.
 * 3) In the Export to a file dialog box, click Comma Separated Values (Windows) or Comma Separated Values (DOS) depending on your operating system, and then click Next.
 * 4) When you are prompted to Select a folder to export from, click the same folder that you used when you imported your personal address book, and then click Next.
 * 5) When you are prompted to Save exported file as, type the location of your personal address book, or click Browse to search for your personal address book, click OK, and then click Next.
 * 6) Click to select the The following actions will be performed check box, and then click Finish.

The contacts are exported to the new folder.

If Microsoft Excel is installed on your computer, the text file opens in Excel. This file can also be opened in the Notepad.

