 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / December 2005built in fields of Outlook
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 If you are looking for the English names of the ContactItem properties, the following MSDN reference may be useful: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaol10/html/ol objContactItem.asp  SignatureDavid Lloyd MCSD .NET http://LemingtonConsulting.com This response is supplied "as is" without any representations or warranties. 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 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 > If you are looking for the English names of the ContactItem properties, > the [quoted text clipped - 16 lines] > Thanks for help > Hugo The OUTLOOK OBJECT MODEL that is provided in OUTLOOK HELP should have all of the information that you're looking for. I am not bilingual and as such have never worked with an ENGLISH and a foreign-language version of Outlook side-by-side, so I'm not certain of the degree to which MS has been dilligent in being consistent between versions. In HELP, you'll need to look under each specific type of Item (MailItem, AppointmentItem, ContactItem, etc) to see the specific properties available for each. To my knowledge, the properties map one-for-one to the 'fields' that you're referring to. > 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 - 37 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
|
©2008 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.