Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Calandaring (http://www.outlookbanter.com/outlook-calandaring/)
-   -   exporting user defined fields from outlook appointment forms (http://www.outlookbanter.com/outlook-calandaring/13324-exporting-user-defined-fields-outlook.html)

Graeme Wright May 1st 06 04:10 AM

exporting user defined fields from outlook appointment forms
 
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?

Milly Staples [MVP - Outlook] May 1st 06 06:44 AM

exporting user defined fields from outlook appointment forms
 
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?



Sue Mosher [MVP-Outlook] May 1st 06 12:51 PM

exporting user defined fields from outlook appointment forms
 
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/legaul...4/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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Graeme Wright" Graeme wrote in message ...
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?



All times are GMT +1. The time now is 05:18 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com