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