Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming VBA / April 2005

Tip: Looking for answers? Try searching our database.

Non English contact field names in non English Office causing VB problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
-mhd - 28 Apr 2005 06:07 GMT
The German version of Outlook uses German language internal field
names.

[German]
Telefon Assistent
Telefon geschäftlich
Telefon geschäftlich 2

instead of

[English]
AssistantTelephoneNumber
BusinessTelephoneNumber
Business2TelephoneNumber

The following statement raises an error because of the space in the
field name.
oContact.Telefon geschäftlich = PhoneNum

whereas
oContact.BusinessTelephoneNumber = PhoneNum naturally works just fine.

How can I get around assigning contact fields with spaces in the name?

Thanks,
-mhd
Michael Bauer - 28 Apr 2005 07:33 GMT
Hi,

the Object Model doesn´t know any other than english names.

Signature

Viele Grüße
Michael Bauer - MVP Outlook

> The German version of Outlook uses German language internal field
> names.
[quoted text clipped - 22 lines]
> Thanks,
> -mhd
-mhd - 28 Apr 2005 14:53 GMT
>the Object Model doesn´t know any other than english names.

That's not the experience I had with my German users because when I
switched to using the German field names in a find operation
"ofolder.Items.Find(sFilter)" it quit crashing with an error.

This would make sense because sfilter is a string and allows spaces
but VB objects to the space when used in this manner...
oContact.Telefon geschäftlich = PhoneNum

When I originally Googled on this problem I found out that the
internal names are German and everything worked fine in searches.

Thanks,
-mhd
Michael Bauer - 28 Apr 2005 15:15 GMT
I´m not sure whether I understand you or not.Regarding to the sample of
your first post: all property names, available via the class names, are
in english only.

If you want to use them in Find or Restrict, then include the strings in
Chr(34), please.

Signature

Viele Grüße
Michael Bauer - MVP Outlook

> >the Object Model doesn´t know any other than english names.
>
[quoted text clipped - 11 lines]
> Thanks,
> -mhd
-mhd - 28 Apr 2005 15:53 GMT
>I´m not sure whether I understand you or not.Regarding to the sample of
>your first post: all property names, available via the class names, are
>in english only.
>
>If you want to use them in Find or Restrict, then include the strings in
>Chr(34), please.

Hi Michael,

This works
sFilter = "[Telefon geschäftlich] = '+49 (179) 5192032'"
ofolder.Items.Find(sFilter)

This doesn't
oContact.Telefon geschäftlich = PhoneNum

Are you saying that in the second example I must revert back to
English names?

-mhd
Michael Bauer - 28 Apr 2005 18:55 GMT
Yes. All available properties you can see in the Object Browser. There
is nothing else for your second example.

Signature

Viele Grüße
Michael Bauer - MVP Outlook

> >I´m not sure whether I understand you or not.Regarding to the sample of
> >your first post: all property names, available via the class names, are
[quoted text clipped - 16 lines]
>
> -mhd
 
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.