Exporting User Defined Tasks Fields

[Guest]

I have defined my User Defined Fields in Tasks.
I would like to export this list to Excel, but I can not find how to set
what fields will be exported. Looks like only the fields that comes by
default to manage tasks are allowed to be exported.

I did as follow:
Running Outlook
Go to Tasks and Define your "User Defined Fields"

Then go to
File > Import and Export >
Choose "Export to a File"
Choose "Microsoft Excel"
Destination File.
And then you will see a window that lists all fields to be exported but you
can not find your "User Defined fields" to be exported into the excel file.

Hope someone can help.
Regards
Jose Genesis

 

[Sue Mosher [MVP-Outlook]]

Outlook doesn't support exporting custom fields directly. Quick and dirty method:

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

 

[Danielle]

I am getting hung up on steps 1 and 2.
Need some help here, thanks!