Microsoft KB Archive/252524

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

Article ID: 252524

Article Last Modified on 2/23/2004

-

APPLIES TO


 * Microsoft Outlook 2000 Standard Edition

-



This article was previously published under Q252524



NOTE: The procedures in this article only apply if you have installed Outlook with the Corporate or Workgroup option. With this option, you can use Messaging Application Programming Interface (MAPI) services. To determine your installation type, click About Microsoft Outlook on the Help menu. If you have the Corporate or Workgroup installation, you see "Corporate or Workgroup".



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 item list.

How to Import Your Personal Address Book to a Contacts Folder
To import your Personal Address Book to a contacts folder, you need to first determine if your Personal Address Book is part of your Outlook profile:
 * 1) On the Tools menu, click Services, and then click the Services tab.
 * 2) If you see Personal Address Book in the list, then your Personal Address Book is part of your Outlook profile. If you do not see Personal Address Book in the list, then your Personal Address Book is not part of your Outlook profile.

If your Personal Address Book is in your Outlook profile, use the following steps to import your Personal Address Book to a contacts folder:
 * 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.

If the Personal Address Book is not in your Outlook profile, use the following steps to import your Personal Address Book to a contacts folder:
 * 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 File to Import box, type the location for your Personal Address Book or click Browse to search for it.
 * 5) Click your Personal Address Book to import it to your Contacts folder, click OK, and then click Next.
 * 6) In the Import a file dialog box, under Select a destination, browse through the folders to the new folder that you created, and then click Next.
 * 7) 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.

