exporting user-defined fields in folder to Excel or Access

J

Jacqueline

I have some user-defined fields in my Contact folder under Public Folders.
How can I export (some of) these 'user-defined fields in folder' to another
application, i.e. Excel or Access or include them in a link to Access?
(These fields do not show using the Import/Export Wizard)
 
S

Sue Mosher [MVP-Outlook]

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/legault/archive/2005/04/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
 
K

Karl Timmermans

You may find one of these two options of interest (there are some others):

#1) This free utility should solve your problem especially if this is either
a one-time or casual requirement (product not related to us - provided for
info only)
http://www.codetwo.com/pages/freeware/outlook_export.php

#2) In the event you require more advanced features - you can review our
export product options :
http://www.contactgenie.com/cgxfeatures.htm

___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com
 

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