Items Find

Hi,
I'm trying to find a item that contains in the beginning of the subject a
certain string. I know that I can find a specific subject using [Subject] =
xxx but I want to find only the beginning or if the subject contains certain
string.

Is this possible?

Regards,
)-- July --)

Am Fri, 7 Apr 2006 12:16:14 -0300 schrieb Julieta Prandi:

July, in Outlook >= XP you can use the AdvancedSearch method. In OL 2000
you´d need to loop through all items and check each subject, e.g. with the
InStr function.

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


> Hi,
> I'm trying to find a item that contains in the beginning of the subject a
> certain string. I know that I can find a specific subject using [Subject]
=
> xxx but I want to find only the beginning or if the subject contains
certain
> string.
>
> Is this possible?
>
> Regards,
> )-- July --)

You can try using > and <:

strFind = "[Subject] >= " & Chr(34) & "xxx" & Chr(34) & _
" AND [Subject] < " Chr(34) & "xxy" & Chr(34)

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

"Julieta Prandi" <jprandi@gmail.com> wrote in message news:Ouyp$ZlWGHA.4652@TK2MSFTNGP04.phx.gbl...
> Hi,
> I'm trying to find a item that contains in the beginning of the subject a
> certain string. I know that I can find a specific subject using [Subject] =
> xxx but I want to find only the beginning or if the subject contains certain
> string.
>
> Is this possible?
>
> Regards,
> )-- July --)
>
>

This is a good workaround.
Thanks you.

"Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message
news:O1n7uwmWGHA.1192@TK2MSFTNGP04.phx.gbl...
You can try using > and <:

strFind = "[Subject] >= " & Chr(34) & "xxx" & Chr(34) & _
" AND [Subject] < " Chr(34) & "xxy" & Chr(34)

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

"Julieta Prandi" <jprandi@gmail.com> wrote in message
news:Ouyp$ZlWGHA.4652@TK2MSFTNGP04.phx.gbl...
> Hi,
> I'm trying to find a item that contains in the beginning of the subject a
> certain string. I know that I can find a specific subject using [Subject]
> =
> xxx but I want to find only the beginning or if the subject contains
> certain
> string.
>
> Is this possible?
>
> Regards,
> )-- July --)
>
>