![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: export, fields, folderquot, outlook, quotuserdefined |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
I have additional fields for my contacts under the user-defined fields, but
when I try to export to excel, they don't show up under the mapping. How do I get them on my spreadsheet? |
| Ads |
|
#2
|
|||
|
|||
|
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. 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/legaul...4/08/4502.aspx 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 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Halfpint" wrote in message ... I have additional fields for my contacts under the user-defined fields, but when I try to export to excel, they don't show up under the mapping. How do I get them on my spreadsheet? |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Cannot "Open" "Import/Export' or use "Data File Management" | Ed Isenberg | Outlook - Installation | 3 | July 16th 06 01:31 AM |
| Outlook, user defined fields | Mel | Outlook - Using Contacts | 3 | June 21st 06 06:55 PM |
| user-defined fields do not export from contacts to a *.cvs file | steve | Outlook - Using Contacts | 4 | April 26th 06 09:21 PM |
| export file - user defined fields | adi bali | Outlook - Using Contacts | 2 | March 20th 06 11:29 AM |
| Export & Import of outlook 2003 "User Defined Fields" at folder le | Kamele0n | Outlook - Using Contacts | 1 | February 25th 06 05:34 PM |