Exporting the Customer ID field in Outlook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gena - 03 Mar 2006 17:30 GMT

I need to export the Customer ID field from Outlook to Excel. The
Customer ID field is not present in the Map Custom Fields option. Does
anyone know how to bring this information over to Excel. Thanks!

Reply to this Message

Sue Mosher [MVP-Outlook] - 03 Mar 2006 18:09 GMT

Quick and dirty method:

1. Put all the items you want to export 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

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

>I need to export the Customer ID field from Outlook to Excel. The
> Customer ID field is not present in the Map Custom Fields option. Does
> anyone know how to bring this information over to Excel. Thanks!

Reply to this Message

IvKo - 04 Mar 2006 07:51 GMT

Try "IMI Contacts Exporter" from
http://www.imibo.com/imidev/Exchange/imice.htm - Exports Contacts to MS
Access 2000 table or MS Excel file.

> I need to export the Customer ID field from Outlook to Excel. The
> Customer ID field is not present in the Map Custom Fields option. Does
> anyone know how to bring this information over to Excel. Thanks!

Reply to this Message