|
| 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. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
September 28th 06, 04:32 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
Export Custom Fields
Created custom field called "Login". Populated this field with data and
would like to export this field to a Excel File. Whithin "Export to a File" dialog box, I click on "Map Custom Fields". The custom field I created is not listed there. Does anyone know how to export a custom field. Thanks!!! 
|
| Ads |
|
#2
October 1st 06, 08:38 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Export Custom Fields
Outlook doesn't support exporting custom fields directly. 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 The alternatives are to write your own custom VBA code or to 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 "crwnsvn" wrote in message ... Created custom field called "Login". Populated this field with data and would like to export this field to a Excel File. Whithin "Export to a File" dialog box, I click on "Map Custom Fields". The custom field I created is not listed there. Does anyone know how to export a custom field. Thanks!!!
|
|
#3
October 19th 06, 07:20 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Export Custom Fields
After the data (including the "user-defined" fields) are copied (not
exported) to Excel using this procedure, can they be pasted (not imported) back in? I wanted to manipulate my e-mail address in Excel (globally replace mail-domain string) then pull back into Excel. Unfortunately, I have some "user-defined" fields and that is hanging me up. "Sue Mosher [MVP-Outlook]" wrote: Outlook doesn't support exporting custom fields directly. 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 The alternatives are to write your own custom VBA code or to 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 "crwnsvn" wrote in message ... Created custom field called "Login". Populated this field with data and would like to export this field to a Excel File. Whithin "Export to a File" dialog box, I click on "Map Custom Fields". The custom field I created is not listed there. Does anyone know how to export a custom field. Thanks!!!
|
|
#4
October 19th 06, 08:21 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Export Custom Fields
No, you can't copy and paste data into Outlook. Use one of the other methods on the second page I suggested.
-- 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 "JonMulder" wrote in message ... After the data (including the "user-defined" fields) are copied (not exported) to Excel using this procedure, can they be pasted (not imported) back in? I wanted to manipulate my e-mail address in Excel (globally replace mail-domain string) then pull back into Excel. Unfortunately, I have some "user-defined" fields and that is hanging me up. "Sue Mosher [MVP-Outlook]" wrote: Outlook doesn't support exporting custom fields directly. 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 The alternatives are to write your own custom VBA code or to use a third-party application. See http://www.outlookcode.com/d/customimport.htm "crwnsvn" wrote in message ... Created custom field called "Login". Populated this field with data and would like to export this field to a Excel File. Whithin "Export to a File" dialog box, I click on "Map Custom Fields". The custom field I created is not listed there. Does anyone know how to export a custom field. Thanks!!!
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| EXPORT CUSTOM FORM FIELDS TO A DATABASE | Sam | Outlook - Using Forms | 5 | September 20th 06 08:10 PM |
| How do I export custom fields into excel? | Sarah S. | Outlook - General Queries | 0 | September 12th 06 12:15 AM |
| copy custom task with custom fields | VinceGSMW | Outlook - General Queries | 3 | May 31st 06 04:11 AM |
| Map fields during export | Lacie | Outlook - Calandaring | 1 | April 14th 06 11:02 PM |
| How do I export a contacts list which includes custom fields | CarrieW | Outlook - Using Contacts | 2 | March 28th 06 08:47 PM |
Linear Mode
