How do I export the fields I defined in the task form to Access?

G

Guest

I have created the fields I need in Tasks however when I try to export to
Access it doesn't allow me to include the "owner" data.
 
S

Sue Mosher [MVP-Outlook]

Outlook doesn't support exporting custom fields. 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

Otherwise, you'd have to write custom code or 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fields and custom fields 0
How to export TASKS with details such as OWNER, etc to Excel ? 1
User-defined field in Task folders - transferable? 2
How can I export ALL data in an Outlook task to Excel or Access 1
Exporting User Defined Tasks Fields 2
How do I export User Defined fields from Outlook? 2
Include "Owner" column, Outlook Task Export to Access 1
Outlook 2003 task form 3

Top