built in fields of Outlook

  • Thread starter Thread starter Hugo Lefebvre
  • Start date Start date
H

Hugo Lefebvre

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/olobjContactItem.asp

--
David 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
 
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.

Educo said:
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
following MSDN reference may be useful:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaol10/html/olobjContactItem.asp

--
David 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
Click to expand...
Click to expand...
 
Back
Top