How do I export contacts to excel with multiple user defined fiel.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James - 08 Feb 2006 01:46 GMT

We have an outlook contacts list with mutiple user defined fields, however
when I go to export the dbase to excel most of the custom/user defined fields
do not appear in the mapping.

We would like to be able to export our whole data base, not just fragments
of it.

Any assistance would be appreciated.

Reply to this Message

Sue Mosher [MVP-Outlook] - 08 Feb 2006 03:24 GMT

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.

Otherwise, you'd have to write custom code or use a third-party application. See http://www.outlookcode.com/d/customimport.htm .

Signature

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

> We have an outlook contacts list with mutiple user defined fields, however
> when I go to export the dbase to excel most of the custom/user defined fields
[quoted text clipped - 4 lines]
>
> Any assistance would be appreciated.

Reply to this Message

James - 08 Feb 2006 04:19 GMT

Now why didn't I think of that ?!

Worked a treat. Thank you.

> Outlook doesn't support exporting custom fields. Quick and dirty method:
>
[quoted text clipped - 14 lines]
> >
> > Any assistance would be appreciated.

Reply to this Message

Murray - 10 Feb 2006 20:50 GMT

Sorry for jumping in to an ongoing thread, but I need some help in this area
too!

My client has about 2000 contacts, with somewhere near half of them in a
distribution list. He needs to export this list from Outlook to Excel. I
think the instructions below are what he needs to do - but I have some
questions.

1. What do you mean by putting the items from your form into one folder?
2. How do I use a table view?

Clearly, I am not an Outlook user! 8)

Would this process work for distribution lists?

Signature

Murray
--------------
MVP FrontPage

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.

Otherwise, you'd have to write custom code or use a third-party application.
See http://www.outlookcode.com/d/customimport.htm .

Signature

> We have an outlook contacts list with mutiple user defined fields, however
> when I go to export the dbase to excel most of the custom/user defined
[quoted text clipped - 5 lines]
>
> Any assistance would be appreciated.

Reply to this Message