• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 179
  • Last Modified:

outlook search

I have to perform search on the outlook.pst files programmatically.
I have to search the subject and body of the mails as it is provided in microsoft outlook itself.
for eg if i have a search criteria like
"welcome town"
if the subject of my first mail in outlook is
"welcome" and the second one has "welcome hello town"
then only the second one should come
i have used restrict method of outlook 9.0 object library but i get the result only if i give the whole subject as search string ie
"welcome hello town"
Waiting for the reply.Thanks!!!!!
1 Solution
Ryan ChongCommented:
Hi shivanit,

Here is an example:

Private Sub Command3_Click()
    Dim iOutlook As Outlook.Application
    Dim myitem As Outlook.MailItem
    Dim myFolder As Outlook.MAPIFolder
    Dim myAttach As Outlook.Attachment
    Dim SearchString As String
    SearchString = "Welcome"
    Set iOutlook = New Outlook.Application
    Set myFolder = iOutlook.GetNamespace("MAPI").GetDefaultFolder(olFolderInbox)

    For i = 1 To myFolder.Items.Count
        Set myitem = myFolder.Items(i)
        If InStr(1, myitem.Subject, SearchString) > 0 Then 'If InStr(1, myitem.Subject, SearchString) = 1 Then 'Perform Like% method
            List1.AddItem myitem.SenderName & " " & myitem.Subject
        End If
    Next i
    Set myitem = Nothing
    Set myFolder = Nothing
    Set iOutlook = Nothing
End Sub

Hope this help
Hi shivanit,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept ryancys's comment(s) as an answer.

shivanit, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.
DanRollins -- EE database cleanup volunteer
Moving to the PAQ

Experts Exchange Moderator
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now