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,

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/legaul...4/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

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"JoeC" wrote in message ...
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,

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

"Sue Mosher [MVP-Outlook]" wrote:

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/legaul...4/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

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"JoeC" wrote in message ...
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,