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

[Guest]

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.

 

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

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

 

[Guest]

Now why didn't I think of that ?!

Worked a treat. Thank you.

 

[Murray]

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?

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

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers