Exporting an Outlook Task List

[maximus_max]

I am trying to export an Outlook Task list to an Excel file using the
Import/Export feature in Outlook. The export does succeed, but only
with a limited number of fields. One specific field that I want to
export is the 'created' field. However, this field is not available in
the field chooser, oddly enough. Does anyone have any ideas about how
to add additional fields?

thanks,

Maximus_max

 

[Sue Mosher [MVP-Outlook]]

The Created field doesn't export. Quick and dirty workaround:

1. Put all the items from your form in one folder.
2. Use a table view to display all the data fields that you want to export to Excel.
3. Choose Edit | Select All.
4. Choose Edit | Copy.
5. Paste to Excel.

If some of the fields are multi-line, see Eric Legault's handy tip for an Excel formula to break up the lines -- http://blogs.officezealot.com/legault/archive/2005/04/08/4502.aspx

The alternatives are to write your own custom VBA code or to use a third-party application. See http://www.outlookcode.com/d/customimport.htm


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers