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 | Display Modes |
|
#1
|
|||
|
|||
Exporting User defined Contact Field
I created a user defined field under the Customize current field - fields -
new field in Outlook Contacts. The new field is a Yes / No type. When I try to export the contacts to either MS Excel or MS Access that field is not available for export. Is there anyway to export ALL Contact fields -- including user created fields. I also tried to change the existing USER FIELD 1 field to a YES/NO type, however Outlook does not provide that abiltiy either. I'm using Outlook 2003 SP2 HELP Thanks -- Keith |
#2
|
|||
|
|||
Exporting User defined Contact Field
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. You can't change the fields available for export. However, if you use Access to set up a linked table connected to your mail folder, you will see the Received date among the available properties. Third-party export tools are also available; see http://www.outlookcode.com/d/customimport.htm#tools 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 "Keith" wrote in message ... I created a user defined field under the Customize current field - fields - new field in Outlook Contacts. The new field is a Yes / No type. When I try to export the contacts to either MS Excel or MS Access that field is not available for export. Is there anyway to export ALL Contact fields -- including user created fields. I also tried to change the existing USER FIELD 1 field to a YES/NO type, however Outlook does not provide that abiltiy either. I'm using Outlook 2003 SP2 HELP Thanks -- Keith |
#3
|
|||
|
|||
Exporting User defined Contact Field
Sue - Thank you -- you are a hugh help. I used the link you provided to
navigate to the Microsoft support site (support.microsoft) and implemented the code for the article 290792 rev 6.0 The code imports my user defined field perfectly using the format - rst!AccessFieldName = c.Userproperties("OutlookPropertyName") Also imports all the other Contact fields defined in the example code that I copied from the Microsoft website. I tried adding the pre-defined Contacts Field called "Modified" ..the code bombs with the error - Run time error 438 " Object doesnt support this property or method. I have the Microsoft Office 11.0 object, Microsoft Outlook 11.0, DAO 3.6 Object, Access 11.0, Visual Basic for Applications, OLE Automation and MS Active X data obj 2.1 Libraries references set. That line of code that bombs is - rst!Modified = c.Modified I also tried rst!Modified = c.userProperties("Modified") which also bombed. Any ideas? thanks Keith -- Keith "Sue Mosher [MVP-Outlook]" wrote: 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. You can't change the fields available for export. However, if you use Access to set up a linked table connected to your mail folder, you will see the Received date among the available properties. Third-party export tools are also available; see http://www.outlookcode.com/d/customimport.htm#tools 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 "Keith" wrote in message ... I created a user defined field under the Customize current field - fields - new field in Outlook Contacts. The new field is a Yes / No type. When I try to export the contacts to either MS Excel or MS Access that field is not available for export. Is there anyway to export ALL Contact fields -- including user created fields. I also tried to change the existing USER FIELD 1 field to a YES/NO type, however Outlook does not provide that abiltiy either. I'm using Outlook 2003 SP2 HELP Thanks -- Keith |
#4
|
|||
|
|||
Exporting User defined Contact Field
3 problems, any one of which would sink your boat:
1) The name of the property is not Modified, but LastModificationTime. 2) It's a built-in property, so you would not use UserProperties to work with it. See http://www.outlookcode.com/d/propsyntax.htm 3) It's a read-only property, so you can't set it. -- 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 "Keith" wrote in message ... Sue - Thank you -- you are a hugh help. I used the link you provided to navigate to the Microsoft support site (support.microsoft) and implemented the code for the article 290792 rev 6.0 The code imports my user defined field perfectly using the format - rst!AccessFieldName = c.Userproperties("OutlookPropertyName") Also imports all the other Contact fields defined in the example code that I copied from the Microsoft website. I tried adding the pre-defined Contacts Field called "Modified" ..the code bombs with the error - Run time error 438 " Object doesnt support this property or method. I have the Microsoft Office 11.0 object, Microsoft Outlook 11.0, DAO 3.6 Object, Access 11.0, Visual Basic for Applications, OLE Automation and MS Active X data obj 2.1 Libraries references set. That line of code that bombs is - rst!Modified = c.Modified I also tried rst!Modified = c.userProperties("Modified") which also bombed. Any ideas? thanks Keith -- Keith "Sue Mosher [MVP-Outlook]" wrote: 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. You can't change the fields available for export. However, if you use Access to set up a linked table connected to your mail folder, you will see the Received date among the available properties. Third-party export tools are also available; see http://www.outlookcode.com/d/customimport.htm#tools Otherwise, you'd have to write custom code or use a third-party application. See http://www.outlookcode.com/d/customimport.htm . "Keith" wrote in message ... I created a user defined field under the Customize current field - fields - new field in Outlook Contacts. The new field is a Yes / No type. When I try to export the contacts to either MS Excel or MS Access that field is not available for export. Is there anyway to export ALL Contact fields -- including user created fields. I also tried to change the existing USER FIELD 1 field to a YES/NO type, however Outlook does not provide that abiltiy either. I'm using Outlook 2003 SP2 HELP Thanks -- Keith |
#5
|
|||
|
|||
Exporting User defined Contact Field
OK Sue, you are amazing. The name was LastModificatonTime so that works now.
Where can I find a list of property names, as LastModificationTime is only identified as Modified in Outlook 2003 SP2. The other property name that does not work is rst!User_1 = c.UserField1 rst!Children = c. Children thanks again for your help -- Keith "Sue Mosher [MVP-Outlook]" wrote: 3 problems, any one of which would sink your boat: 1) The name of the property is not Modified, but LastModificationTime. 2) It's a built-in property, so you would not use UserProperties to work with it. See http://www.outlookcode.com/d/propsyntax.htm 3) It's a read-only property, so you can't set it. -- 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 "Keith" wrote in message ... Sue - Thank you -- you are a hugh help. I used the link you provided to navigate to the Microsoft support site (support.microsoft) and implemented the code for the article 290792 rev 6.0 The code imports my user defined field perfectly using the format - rst!AccessFieldName = c.Userproperties("OutlookPropertyName") Also imports all the other Contact fields defined in the example code that I copied from the Microsoft website. I tried adding the pre-defined Contacts Field called "Modified" ..the code bombs with the error - Run time error 438 " Object doesnt support this property or method. I have the Microsoft Office 11.0 object, Microsoft Outlook 11.0, DAO 3.6 Object, Access 11.0, Visual Basic for Applications, OLE Automation and MS Active X data obj 2.1 Libraries references set. That line of code that bombs is - rst!Modified = c.Modified I also tried rst!Modified = c.userProperties("Modified") which also bombed. Any ideas? thanks Keith -- Keith "Sue Mosher [MVP-Outlook]" wrote: 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. You can't change the fields available for export. However, if you use Access to set up a linked table connected to your mail folder, you will see the Received date among the available properties. Third-party export tools are also available; see http://www.outlookcode.com/d/customimport.htm#tools Otherwise, you'd have to write custom code or use a third-party application. See http://www.outlookcode.com/d/customimport.htm . "Keith" wrote in message ... I created a user defined field under the Customize current field - fields - new field in Outlook Contacts. The new field is a Yes / No type. When I try to export the contacts to either MS Excel or MS Access that field is not available for export. Is there anyway to export ALL Contact fields -- including user created fields. I also tried to change the existing USER FIELD 1 field to a YES/NO type, however Outlook does not provide that abiltiy either. I'm using Outlook 2003 SP2 HELP Thanks -- Keith |
#6
|
|||
|
|||
Exporting User defined Contact Field
When in doubt, check the object browser: Press ALt+F11 to open the VBA environment in Outlook, then press F2. Switch from All Libraries to Outlook to browse all Outlook objects and their properties, methods, and events. Select any object or member, then press F1 to see its Help topic.
-- 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 "Keith" wrote in message ... OK Sue, you are amazing. The name was LastModificatonTime so that works now. Where can I find a list of property names, as LastModificationTime is only identified as Modified in Outlook 2003 SP2. The other property name that does not work is rst!User_1 = c.UserField1 rst!Children = c. Children thanks again for your help -- Keith "Sue Mosher [MVP-Outlook]" wrote: 3 problems, any one of which would sink your boat: 1) The name of the property is not Modified, but LastModificationTime. 2) It's a built-in property, so you would not use UserProperties to work with it. See http://www.outlookcode.com/d/propsyntax.htm 3) It's a read-only property, so you can't set it. "Keith" wrote in message ... Sue - Thank you -- you are a hugh help. I used the link you provided to navigate to the Microsoft support site (support.microsoft) and implemented the code for the article 290792 rev 6.0 The code imports my user defined field perfectly using the format - rst!AccessFieldName = c.Userproperties("OutlookPropertyName") Also imports all the other Contact fields defined in the example code that I copied from the Microsoft website. I tried adding the pre-defined Contacts Field called "Modified" ..the code bombs with the error - Run time error 438 " Object doesnt support this property or method. I have the Microsoft Office 11.0 object, Microsoft Outlook 11.0, DAO 3.6 Object, Access 11.0, Visual Basic for Applications, OLE Automation and MS Active X data obj 2.1 Libraries references set. That line of code that bombs is - rst!Modified = c.Modified I also tried rst!Modified = c.userProperties("Modified") which also bombed. Any ideas? thanks Keith -- Keith "Sue Mosher [MVP-Outlook]" wrote: 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. You can't change the fields available for export. However, if you use Access to set up a linked table connected to your mail folder, you will see the Received date among the available properties. Third-party export tools are also available; see http://www.outlookcode.com/d/customimport.htm#tools Otherwise, you'd have to write custom code or use a third-party application. See http://www.outlookcode.com/d/customimport.htm . "Keith" wrote in message ... I created a user defined field under the Customize current field - fields - new field in Outlook Contacts. The new field is a Yes / No type. When I try to export the contacts to either MS Excel or MS Access that field is not available for export. Is there anyway to export ALL Contact fields -- including user created fields. I also tried to change the existing USER FIELD 1 field to a YES/NO type, however Outlook does not provide that abiltiy either. I'm using Outlook 2003 SP2 HELP Thanks -- Keith |
#7
|
|||
|
|||
Exporting User defined Contact Field
I'm trying to find Sue Mosher-MVP here...
Sorry to inject a new thread into an old one. I'm not good at using newsgroups. I wonder whether Sue or anyone has any idea what happened to the "Contacts" field (or its content on import) when OL 2003 is upgraded to OL 2007? My 2003 data had a lot of cross-links. Are they lost now? Thanks, Dave --------------- "Sue Mosher [MVP-Outlook]" wrote: 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. You can't change the fields available for export. However, if you use Access to set up a linked table connected to your mail folder, you will see the Received date among the available properties. Third-party export tools are also available; see http://www.outlookcode.com/d/customimport.htm#tools 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 "Keith" wrote in message ... I created a user defined field under the Customize current field - fields - new field in Outlook Contacts. The new field is a Yes / No type. When I try to export the contacts to either MS Excel or MS Access that field is not available for export. Is there anyway to export ALL Contact fields -- including user created fields. I also tried to change the existing USER FIELD 1 field to a YES/NO type, however Outlook does not provide that abiltiy either. I'm using Outlook 2003 SP2 HELP Thanks -- Keith |
#8
|
|||
|
|||
Exporting User defined Contact Field
Importing contact information *always* breaks contact links in every version. Furthermore, upgrading on the same machine never requires a data import.
The way to maintain contact links is simply to continue to use the same Personal Folders .pst file, in the same location on the hard drive. Next time, please start a new topic thread rather than piggybacking on an unrelated topic. -- 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 "OneDave" wrote in message ... I'm trying to find Sue Mosher-MVP here... Sorry to inject a new thread into an old one. I'm not good at using newsgroups. I wonder whether Sue or anyone has any idea what happened to the "Contacts" field (or its content on import) when OL 2003 is upgraded to OL 2007? My 2003 data had a lot of cross-links. Are they lost now? |
#9
|
|||
|
|||
Exporting User defined Contact Field
Hi Sue:
I've been reading your string on how to export out user defined fields, because I need these fields in Access for reporting purposes. When I use a table view to display the fields, they are not in there. Why is it so hard to get these fields exported out? This should be easy and it's not. Can you help me? "Sue Mosher [MVP-Outlook]" wrote: 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. You can't change the fields available for export. However, if you use Access to set up a linked table connected to your mail folder, you will see the Received date among the available properties. Third-party export tools are also available; see http://www.outlookcode.com/d/customimport.htm#tools 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 "Keith" wrote in message ... I created a user defined field under the Customize current field - fields - new field in Outlook Contacts. The new field is a Yes / No type. When I try to export the contacts to either MS Excel or MS Access that field is not available for export. Is there anyway to export ALL Contact fields -- including user created fields. I also tried to change the existing USER FIELD 1 field to a YES/NO type, however Outlook does not provide that abiltiy either. I'm using Outlook 2003 SP2 HELP Thanks -- Keith |
#10
|
|||
|
|||
Exporting User defined Contact Field
As Sue stated - neither importing/exporting of custom fields is support nor
are these accessible via the Access link. Other alternative options to Sue's suggestion: #1 - Use this free program (not related to us): http://www.codetwo.com/pages/freewar...ook_export.php Or you are always welcome to check our exporter products (not free) in case the additional options/features are of interest - one of which would be to schedule any export via the task scheduler to a new .mdb which could then be used as a linked table or alternatively into your Access MDB directly creating a new table on each export or updating an existing table (update feature only available in CG Exporter Premium version). http://www.contactgenie.com/cgxfeatures.htm Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "Susan May" wrote in message ... Hi Sue: I've been reading your string on how to export out user defined fields, because I need these fields in Access for reporting purposes. When I use a table view to display the fields, they are not in there. Why is it so hard to get these fields exported out? This should be easy and it's not. Can you help me? "Sue Mosher [MVP-Outlook]" wrote: 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. You can't change the fields available for export. However, if you use Access to set up a linked table connected to your mail folder, you will see the Received date among the available properties. Third-party export tools are also available; see http://www.outlookcode.com/d/customimport.htm#tools 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 "Keith" wrote in message ... I created a user defined field under the Customize current field - fields - new field in Outlook Contacts. The new field is a Yes / No type. When I try to export the contacts to either MS Excel or MS Access that field is not available for export. Is there anyway to export ALL Contact fields -- including user created fields. I also tried to change the existing USER FIELD 1 field to a YES/NO type, however Outlook does not provide that abiltiy either. I'm using Outlook 2003 SP2 HELP Thanks -- Keith |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
WEBDAV - User defined fields - Not updating | IndraKumar | Contacts | 0 | July 8th, 2005 06:09 AM |
WebDav - Outlook Contact Notes Field | Sumanth Peddi via OfficeKB.com | Contacts | 1 | June 29th, 2005 02:33 PM |
Can I copy the contents of User Field 1 to User Field 4? | Robert Judge | Contacts | 1 | January 13th, 2005 02:39 PM |
How do I display a contact picture in a user defined form or cust. | M-Kaps | Contacts | 5 | January 10th, 2005 09:23 PM |
Columns and layout problems | Phil | Setting Up & Running Reports | 4 | August 18th, 2004 01:34 PM |