Exporting custom contact form to excel

[Guest]

I have created a form based on contact item. I am able to create contacts
using this form. When I attempt to export to excel, none of the new fields
I created are showing up to be exported. How do I get the export to use the
new form and not the default contact form.

Same question for importing.

 

[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

 

[Hollis Paul]

How do I get the export to use the
new form and not the default contact form.

Same question for importing.

You don't. The export wizards will not export custom, user-defined
fields. There are four, standard User fields, and some other fields,
like Mileage and Billing Information that Microsoft vows never to touch
themselves. If you need one or two other fields, and you really want
to use the export wizards, you can select other fields that you do not
expect to use, even though Microsoft may have defined them for
something else, and put your data there. It is risky, but it allows
you to use the Export wizards.

If you have more fields than that, then use User Defined Fields (UDFs)
in the Folder, and write code for the save or send event that will push
the data out to your Excel spreadsheet.

Go to www.outlookcode.com, and search on "custom field export code",
without the quotes.

This looks like your best bet:

Import and Exporting Data from Custom Microsoft Outlook Forms
5/11/2007
How to import or export data from custom Microsoft Outlook fields and
forms via Microsoft Access, Microsoft Excel and text files
http://www.outlookcode.com/archive0/d/customimport.htm