exporting user defined fields from outlook appointment forms

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

Milly Staples [MVP - Outlook]

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

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
 

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