OL2000: Unable to Export Date Field from Mail Items

ID: Q240226


The information in this article applies to:
  • Microsoft Outlook 2000


SYMPTOMS

Outlook only imports and exports a limited number of fields. When Outlook exports e-mail messages, the date fields are not included.


CAUSE

This is a limitation of the Export wizard.


WORKAROUND

In order to import e-mail date fields, you can use a database program solution.

Foxpro

For example, if you want to convert Outlook items to a Foxpro database file, you may find a Foxpro solution at the following Internet address:
http://www.foxshare.com
There is a programming solution in the Frequently Asked Questions (FAQ) section titled, "How to use FoxPro to transfer your mail to a DBF?"

Access

If you want to convert Outlook items to a Microsoft Access 2000 .mdb file:
  1. Start Access, and open a new blank database.


  2. On the File menu, point to Get External Data, and then click Import.


  3. In the File of type list, click to select Exchange(). If prompted, click to choose the correct profile.


  4. Click the MAPI folder, and then click Finish.


You should now have a new table, named for your chosen MAPI folder, that contains the appropriate date fields for the imported items. After this information is in Access, you can export it to any other format supported by access, such as an Excel file.

Additional query words: OL2K

Keywords : kbconversion
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: October 28, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.