exporting user defined fields from outlook appointment forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.

--
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
| 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?
 
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
 
Back
Top