How do I export a user-defined field from Contacts to Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

206piglet - 06 Dec 2004 02:33 GMT

I created a user-defined field in my Contacts. Now, I'm exporting info from
Outlook to Excel but the user-defined column is not successfully
transferring. All other data is accurate and I even see the column called
"user1", "user 2", etc...but my info is not there. Any suggestions?

Reply to this Message

Milly Staples [MVP - Outlook] - 06 Dec 2004 06:43 GMT

Custom fields do not import/export.

Signature

--?
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After furious head scratching, 206piglet asked:

| I created a user-defined field in my Contacts. Now, I'm exporting
| info from Outlook to Excel but the user-defined column is not
| successfully transferring. All other data is accurate and I even see
| the column called "user1", "user 2", etc...but my info is not there.
| Any suggestions?

Reply to this Message

Sue Mosher [MVP-Outlook] - 06 Dec 2004 13:12 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
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

>I created a user-defined field in my Contacts. Now, I'm exporting info
>from
> Outlook to Excel but the user-defined column is not successfully
> transferring. All other data is accurate and I even see the column called
> "user1", "user 2", etc...but my info is not there. Any suggestions?

Reply to this Message