Exporting a User-Defined Field

[JoeC]

I've created new field (combo box) on P2 using the Appointment Form as the
basis. The form is Published and appears in the correct calendar when opened.

Problem: I need to Export the contents of that field to Excel or a
tab-separated file. When I export using the Wizard, the field fails to
appear.

How can I do this?

Regards,

 

[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/article.aspx?ID=23

 

[JoeC]

Ms. Mosher,

Thanks for the reply. This works - as you write - after a
fashion. We were trying to develop a "canned" method
for others to use. Guess that this means programming.

JoeC