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
Sue - I don't know what they pay you, but it is not enough. Thanks a million.
This answers all my questions. -- Keith "Sue Mosher [MVP-Outlook]" wrote: 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 |
#8
|
|||
|
|||
Exporting User defined Contact Field
Sue OK... seems that I think all is well when ...alas something else goes
wrong... I used the Object Browser to find the properties/methods for all the items that I needed to export, some would have not been easy to guess (User1 for the Contact Item "User Field 1". EXCEPT the field in Contacts called Children, which according to the object browser is "Children" code in rst!Children = c.Children and get error. Must be known by another name that the object browser does not show??? Any Ideas? -- Keith "Sue Mosher [MVP-Outlook]" wrote: 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 |
#9
|
|||
|
|||
Exporting User defined Contact Field
What error? Break the statement apart to see whether it's on the Access side or the OUtlook side:
strChildren = c.Children rst!Children = strChildren -- 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 OK... seems that I think all is well when ...alas something else goes wrong... I used the Object Browser to find the properties/methods for all the items that I needed to export, some would have not been easy to guess (User1 for the Contact Item "User Field 1". EXCEPT the field in Contacts called Children, which according to the object browser is "Children" code in rst!Children = c.Children and get error. Must be known by another name that the object browser does not show??? |
#10
|
|||
|
|||
Exporting User defined Contact Field
I’m so embarrassed, the problem was not with Access or Outlook, it was with
ME, The Access default text field size (50) was too small to handle the one instance of 7 kids. Set default size to 200 and presto. Thank you again, you provide a wonderful service.-- Keith "Sue Mosher [MVP-Outlook]" wrote: What error? Break the statement apart to see whether it's on the Access side or the OUtlook side: strChildren = c.Children rst!Children = strChildren -- 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 OK... seems that I think all is well when ...alas something else goes wrong... I used the Object Browser to find the properties/methods for all the items that I needed to export, some would have not been easy to guess (User1 for the Contact Item "User Field 1". EXCEPT the field in Contacts called Children, which according to the object browser is "Children" code in rst!Children = c.Children and get error. Must be known by another name that the object browser does not show??? |
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 |