A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Using Restrict function in multiple languages



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old February 28th 06, 06:37 AM posted to microsoft.public.outlook.program_vba
Ramesh
external usenet poster
 
Posts: 13
Default Using Restrict function in multiple languages

I have an Outlook addin. In one of the methods, I am using the Restrict
method to restrict the appointment items I am getting from a folder based on
the Category name. So the restrict condition goes like this "[Categories] =
'xxxxxx'". It works just fine. But the issue comes when this addin works in a
different language OS environment, for example, Korean. Apparently, the
property names are translated according to the language of the OS and hence
[Categories] may be something else in Korean. Is there a way to solve this
issue? How can I code a restrict condition that will work in multiple
languages? Is there a way to retrieve the property name and then use it to
build the condition? I am giving [Categories] as an example, but I am also
using different properties in the condition. Any help would be greatly
appreciated. Thanks in advance.

(I already posted this in the Office Developer-Addin forum. No one has
responded yet. My programming language is C++, but I don't think it matters
for this issue)
Ads
  #2  
Old February 28th 06, 01:15 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Using Restrict function in multiple languages

You might want to use AdvancedSearch instead of Restrict, since AdvancedSearch uses schema names instead of localized field names.

--
Sue 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


"Ramesh" wrote in message ...
I have an Outlook addin. In one of the methods, I am using the Restrict
method to restrict the appointment items I am getting from a folder based on
the Category name. So the restrict condition goes like this "[Categories] =
'xxxxxx'". It works just fine. But the issue comes when this addin works in a
different language OS environment, for example, Korean. Apparently, the
property names are translated according to the language of the OS and hence
[Categories] may be something else in Korean. Is there a way to solve this
issue? How can I code a restrict condition that will work in multiple
languages? Is there a way to retrieve the property name and then use it to
build the condition? I am giving [Categories] as an example, but I am also
using different properties in the condition. Any help would be greatly
appreciated. Thanks in advance.

(I already posted this in the Office Developer-Addin forum. No one has
responded yet. My programming language is C++, but I don't think it matters
for this issue)

  #3  
Old March 1st 06, 03:26 AM posted to microsoft.public.outlook.program_vba
Ramesh
external usenet poster
 
Posts: 13
Default Using Restrict function in multiple languages

Hi Sue,

Thanks for the reply. I will look into it. But if I remember correctly,
AdvancedSearch is available only in certain versions of Outlook (2003 I
believe). I want a solution that would work for Outlook 2000 also.

Thanks

"Sue Mosher [MVP-Outlook]" wrote:

You might want to use AdvancedSearch instead of Restrict, since AdvancedSearch uses schema names instead of localized field names.

--
Sue 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


"Ramesh" wrote in message ...
I have an Outlook addin. In one of the methods, I am using the Restrict
method to restrict the appointment items I am getting from a folder based on
the Category name. So the restrict condition goes like this "[Categories] =
'xxxxxx'". It works just fine. But the issue comes when this addin works in a
different language OS environment, for example, Korean. Apparently, the
property names are translated according to the language of the OS and hence
[Categories] may be something else in Korean. Is there a way to solve this
issue? How can I code a restrict condition that will work in multiple
languages? Is there a way to retrieve the property name and then use it to
build the condition? I am giving [Categories] as an example, but I am also
using different properties in the condition. Any help would be greatly
appreciated. Thanks in advance.

(I already posted this in the Office Developer-Addin forum. No one has
responded yet. My programming language is C++, but I don't think it matters
for this issue)


  #4  
Old March 1st 06, 06:57 AM posted to microsoft.public.outlook.program_vba
Michael Bauer
external usenet poster
 
Posts: 435
Default Using Restrict function in multiple languages

Am Tue, 28 Feb 2006 08:15:56 -0500 schrieb Sue Mosher [MVP-Outlook]:

I wonder why there´s a problem. For me, on a German system, they work both
the English and the German names.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


You might want to use AdvancedSearch instead of Restrict, since

AdvancedSearch uses schema names instead of localized field names.
  #5  
Old March 1st 06, 01:41 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Using Restrict function in multiple languages

That's why we always suggest that people include their Outlook version(s) in their initial post.

You have no choice then but to research the localized field names. There's no central source of documentation for that.

--
Sue 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


"Ramesh" wrote in message ...
Hi Sue,

Thanks for the reply. I will look into it. But if I remember correctly,
AdvancedSearch is available only in certain versions of Outlook (2003 I
believe). I want a solution that would work for Outlook 2000 also.

Thanks

"Sue Mosher [MVP-Outlook]" wrote:

You might want to use AdvancedSearch instead of Restrict, since AdvancedSearch uses schema names instead of localized field names.

--
Sue 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


"Ramesh" wrote in message ...
I have an Outlook addin. In one of the methods, I am using the Restrict
method to restrict the appointment items I am getting from a folder based on
the Category name. So the restrict condition goes like this "[Categories] =
'xxxxxx'". It works just fine. But the issue comes when this addin works in a
different language OS environment, for example, Korean. Apparently, the
property names are translated according to the language of the OS and hence
[Categories] may be something else in Korean. Is there a way to solve this
issue? How can I code a restrict condition that will work in multiple
languages? Is there a way to retrieve the property name and then use it to
build the condition? I am giving [Categories] as an example, but I am also
using different properties in the condition. Any help would be greatly
appreciated. Thanks in advance.

(I already posted this in the Office Developer-Addin forum. No one has
responded yet. My programming language is C++, but I don't think it matters
for this issue)


  #6  
Old March 2nd 06, 03:43 AM posted to microsoft.public.outlook.program_vba
Ramesh
external usenet poster
 
Posts: 13
Default Using Restrict function in multiple languages

Michael,

Would you mind posting the code snippet that you use to do the Restrict,
specifically restricting on Categories field?

Thanks for your help

K. Ramesh

"Michael Bauer" wrote:

Am Tue, 28 Feb 2006 08:15:56 -0500 schrieb Sue Mosher [MVP-Outlook]:

I wonder why there´s a problem. For me, on a German system, they work both
the English and the German names.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


You might want to use AdvancedSearch instead of Restrict, since

AdvancedSearch uses schema names instead of localized field names.

  #7  
Old March 2nd 06, 03:51 AM posted to microsoft.public.outlook.program_vba
Ramesh
external usenet poster
 
Posts: 13
Default Using Restrict function in multiple languages

Hi Sue,

Thanks again for your reply and sorry for not including the version number
in my initial post. I can probably get the localized field names by
translating the field names, but there is no guarantee that it will match the
field names used by the Outlook API. The only way, that I know off, would be
to get the translated strings for the field names (as they are used in the
Outlook API) from Microsoft. But I am pretty sure someone must have faced
this problem already and must have found a solution.

If you know of a way or a workaround, please let me know. Thanks

K. Ramesh

"Sue Mosher [MVP-Outlook]" wrote:

That's why we always suggest that people include their Outlook version(s) in their initial post.

You have no choice then but to research the localized field names. There's no central source of documentation for that.

--
Sue 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


"Ramesh" wrote in message ...
Hi Sue,

Thanks for the reply. I will look into it. But if I remember correctly,
AdvancedSearch is available only in certain versions of Outlook (2003 I
believe). I want a solution that would work for Outlook 2000 also.

Thanks

"Sue Mosher [MVP-Outlook]" wrote:

You might want to use AdvancedSearch instead of Restrict, since AdvancedSearch uses schema names instead of localized field names.

--
Sue 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


"Ramesh" wrote in message ...
I have an Outlook addin. In one of the methods, I am using the Restrict
method to restrict the appointment items I am getting from a folder based on
the Category name. So the restrict condition goes like this "[Categories] =
'xxxxxx'". It works just fine. But the issue comes when this addin works in a
different language OS environment, for example, Korean. Apparently, the
property names are translated according to the language of the OS and hence
[Categories] may be something else in Korean. Is there a way to solve this
issue? How can I code a restrict condition that will work in multiple
languages? Is there a way to retrieve the property name and then use it to
build the condition? I am giving [Categories] as an example, but I am also
using different properties in the condition. Any help would be greatly
appreciated. Thanks in advance.

(I already posted this in the Office Developer-Addin forum. No one has
responded yet. My programming language is C++, but I don't think it matters
for this issue)


  #8  
Old March 2nd 06, 07:27 AM posted to microsoft.public.outlook.program_vba
Michael Bauer
external usenet poster
 
Posts: 435
Default Using Restrict function in multiple languages

Am Wed, 1 Mar 2006 19:43:26 -0800 schrieb Ramesh:

Interesting, first I wanted to anwser you this: For fields, like Categories,
it doesn´t work at all - neither in the localized version nor in English.
That is what you can read in the VBA help.

Then I tested and in fact: Restrict works on Categories if you use the
localized version. But it works only if you do know the exact string,
there´s no LIKE operator supported.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


Michael,

Would you mind posting the code snippet that you use to do the Restrict,
specifically restricting on Categories field?

Thanks for your help

K. Ramesh

"Michael Bauer" wrote:

Am Tue, 28 Feb 2006 08:15:56 -0500 schrieb Sue Mosher [MVP-Outlook]:

I wonder why there´s a problem. For me, on a German system, they work

both
the English and the German names.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


You might want to use AdvancedSearch instead of Restrict, since

AdvancedSearch uses schema names instead of localized field names.

  #9  
Old March 2nd 06, 08:07 AM posted to microsoft.public.outlook.program_vba
Ramesh
external usenet poster
 
Posts: 13
Default Using Restrict function in multiple languages

Hi Michael,

Thanks for your reply. But I beg to differ on your statement that "it
doesn't work at all". Restriction on Categories does work but there are
limitations. For my purpose it works well except for this localization issue
I am facing.

You state that "Restrict works on Categories if you use the
localized version". What do you mean? Did you have to use the translated
string for "Categories" in your Restrict condition? And if you did, and if it
worked for you, how did you find out about the exact translated string as
required by the Outlook API? Any help you provide would be of great help.
Thanks again for your help

K. Ramesh


"Michael Bauer" wrote:

Am Wed, 1 Mar 2006 19:43:26 -0800 schrieb Ramesh:

Interesting, first I wanted to anwser you this: For fields, like Categories,
it doesn´t work at all - neither in the localized version nor in English.
That is what you can read in the VBA help.

Then I tested and in fact: Restrict works on Categories if you use the
localized version. But it works only if you do know the exact string,
there´s no LIKE operator supported.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


Michael,

Would you mind posting the code snippet that you use to do the Restrict,
specifically restricting on Categories field?

Thanks for your help

K. Ramesh

"Michael Bauer" wrote:

Am Tue, 28 Feb 2006 08:15:56 -0500 schrieb Sue Mosher [MVP-Outlook]:

I wonder why there´s a problem. For me, on a German system, they work

both
the English and the German names.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


You might want to use AdvancedSearch instead of Restrict, since
AdvancedSearch uses schema names instead of localized field names.


  #10  
Old March 2nd 06, 10:48 AM posted to microsoft.public.outlook.program_vba
Michael Bauer
external usenet poster
 
Posts: 435
Default Using Restrict function in multiple languages

Am Thu, 2 Mar 2006 00:07:26 -0800 schrieb Ramesh:


... Restriction on Categories does work but there are
limitations. For my purpose it works well except for this localization issue
I am facing.


Hm, I intended to tell the same, didn´t I?

I´m a German, so translating "Categories" into my native language and using
that localized name in the Restrict condition isn´t very hard for me :-)

As Sue told already, there´s no MS site translating any words for you.

If you need the Korean translation only then you could try it with babelfish
(http://babelfish.altavista.com/), any other dictionary or just ask friendly
a customer.

If you don´t know your customers respectively their languages then I
wouldn´t use the Restrict function, but search in a loop through the items.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


Hi Michael,

Thanks for your reply. But I beg to differ on your statement that "it
doesn't work at all". Restriction on Categories does work but there are
limitations. For my purpose it works well except for this localization

issue
I am facing.

You state that "Restrict works on Categories if you use the
localized version". What do you mean? Did you have to use the translated
string for "Categories" in your Restrict condition? And if you did, and if

it
worked for you, how did you find out about the exact translated string as
required by the Outlook API? Any help you provide would be of great help.
Thanks again for your help

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to restrict number of newsgroup headers downloaded Adrian Outlook Express 14 March 4th 06 07:44 AM
Using Restrict in Multiple languages Ramesh Add-ins for Outlook 0 February 28th 06 06:41 AM
filtering specific languages seagull Outlook Express 1 February 21st 06 10:38 AM
How do I restrict access to Outlook in limited account using XP Pro? Joe K Outlook - General Queries 1 February 8th 06 03:25 AM
Restrict jim Add-ins for Outlook 2 January 13th 06 08:14 PM


All times are GMT +1. The time now is 04:23 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2024 Outlook Banter.
The comments are property of their posters.