the names of the built-in outlook fields

  • Thread starter Thread starter cov webmaster
  • Start date Start date
C

cov webmaster

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.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
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

"Sue Mosher [MVP-Outlook]" <[email protected]> schreef in bericht
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.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
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.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Educo Gent 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

"Sue Mosher [MVP-Outlook]" <[email protected]> schreef in bericht
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.

cov webmaster said:
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