 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Programming VBA / December 2005the names of the built-in outlook fields
I want to import into 'Outlook Contacts' records from Access. I found sample code in http://support.microsoft.com/?kbid=170320 I use a Dutch version of Access2002 and Outlook 2002. Problem is: where can I find the names of the built-in Outlook fields (I found two field names in the above code: CompanyName and ContactName)? If I use the dutch names of the fields (that I can find in Outlook 2002 - by making a form and then using the field chooser) in VBA code, it doesn't work. Thanks for help Hugo The property names are the same, regardless of the language, and may differ from the field names you see in the FIeld Chooser. You can find the property names in the object browser in VBA.  SignatureSue 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 >I want to import into 'Outlook Contacts' records from Access. I found sample > code in http://support.microsoft.com/?kbid=170320 [quoted text clipped - 7 lines] > Thanks for help > Hugo I've found the property names in VBA. Thanks. But there is still a problem. I use a dutch version of Outlook 2002. I think there are errors in the translation from the Enghish version to the dutch version. Not so easy to explain in another language. I give an example. I use the general form of a contact, tab 'General', home address, postalcode and I fill in: 1234 (this is an example). If I use the tab 'All fields', I find 1234 in the field 'homeaddress, city' and not 'homeaddress, postalcode'. For that reason, I had to program as follows: If ![rel_gemeente] <> "" Then c.HomeAddressState = ![rel_gemeente] If ![rel_postcode] <> "" Then c.HomeAddressCity = ![rel_postcode] where rel_gemeente is the name of the city and rel_postcode is the postalcode Anyway, thanks for help. Hugo The property names are the same, regardless of the language, and may differ from the field names you see in the FIeld Chooser. You can find the property names in the object browser in VBA. SignatureSue 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 >I want to import into 'Outlook Contacts' records from Access. I found >sample [quoted text clipped - 10 lines] > Thanks for help > Hugo That's a different issue. How Outlook resolves typed mailing addresses into individual properties is likely to differ from version to version. The property names themselves are invariable. What's happened in your scenario is that "1234" was resolved to HomeAddressCity. SignatureSue 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 > I've found the property names in VBA. Thanks. But there is still a problem. > I use a dutch version of Outlook 2002. I think there are errors in the [quoted text clipped - 35 lines] >> Thanks for help >> Hugo |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.