Exporting User-Defined Form Fields

G

Guest

I have tried everything I can think of to get the user-defined fields in a published form that is associated to a folder to export with the information in the emails. No luck. None of the exporting even allows you to map user defined fields, they just give you the default fields for a mail item

Environment: Outlook folder storing custom forms with information in user defined fields and the form associated to that folder that needs to be placed into excel or access to analyze information in the fields (like date started and date ended and "cause"

Any ideas on a non-manual way to get that information out?
 
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.

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
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Bill said:
I have tried everything I can think of to get the user-defined fields in a
published form that is associated to a folder to export with the information
in the emails. No luck. None of the exporting even allows you to map user
defined fields, they just give you the default fields for a mail item.
Environment: Outlook folder storing custom forms with information in user
defined fields and the form associated to that folder that needs to be
placed into excel or access to analyze information in the fields (like date
started and date ended and "cause")
 

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

Top