exporting user defined fields from outlook appointment forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Graeme Wright - 01 May 2006 04:10 GMT

I have created a form and use as the default for appointments to capture
specific info about the appointment for a function room in a club. This is
the default form for appointments as the details are on a second tab.

How can I export this information as the default export function only looks
at fields on the standard form?

Reply to this Message

Milly Staples [MVP - Outlook] - 01 May 2006 06:44 GMT

Custom fields cannot be imported or exported without the use of VBA or third
party tools. See http://outlookcode.com for assistance with VBA. Sorry,
don't have the exact URL but you can search this news group via
groups.google.com to see if you can find it.

Signature

Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Graeme Wright asked:

| I have created a form and use as the default for appointments to
| capture specific info about the appointment for a function room in a
[quoted text clipped - 3 lines]
| How can I export this information as the default export function only
| looks at fields on the standard form?

Reply to this Message

Sue Mosher [MVP-Outlook] - 01 May 2006 12:51 GMT

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 .

Signature

Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

>I have created a form and use as the default for appointments to capture
> specific info about the appointment for a function room in a club. This is
> the default form for appointments as the details are on a second tab.
>
> How can I export this information as the default export function only looks
> at fields on the standard form?

Reply to this Message

Rate this thread: