I want to search all the mails I sent to "zeev".
But I don't want to include mails which I've sent to "zeev" and "john"
So, I want to find emails which I've sent only to "zeev".
What is the phrase search word which I have to add?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
I don't think it's possible to define your search criteria using Outlook's Advanced Find, however, an alternative way to accomplish your search is to create a custom view.
The custom view described below uses essentially the same SQL DASL query that I used in my other answer of creating a search folder via a macro. I believe the custom view will be easier to for you to implement.
To create the view:
"urn:schemas:httpmail:displayto" LIKE 'Zeev%' AND NOT "urn:schemas:httpmail:displayto" LIKE '%;%' AND "urn:schemas:httpmail:displaycc" =''
The following macro run once will create a Search Folder that persistently shows messages from Sent Items folder that were sent to only a single specified recipient.
In Outlook open the VBA editor using Alt+F11 and paste the code into the editor. Select a message you sent just to your buddy Zeev and then run the macro. You may need to set macro security to low to run the macro.
Sub CreateSearchFolderForOneRecipient() On Error GoTo Err_CreateSearchFolderForOneRecipient ' Get the email address from a selected message Dim oMail As Outlook.MailItem Set oMail = ActiveExplorer.Selection.Item(1) strSearchFolderName = "Msgs sent only to " & oMail.To If oMail.To = "" Then Exit Sub ElseIf InStr(1, oMail.To, ";") > 0 Then Err.Raise Number:=vbObjectError + 1000, _ Description:="Selected message must have only 1 recipient in To: field" End If Dim strDASLFilter As String ' The trick to identifying messages sent to multiple recipients is the semi-colon ; delimiter. ' Semicolon can be searched using SQL DASL syntax but not in the Advanced Search form GUI ' Description of filter ' Line 1: Messages sent to specified recipient ' Line 2: 'To' field cannot contain semicolon ' LIne 3: 'CC' field must be empty strDASLFilter = Chr(34) & "urn:schemas:httpmail:displayto" & Chr(34) & " = '" & oMail.To & "'" _ & " AND NOT " & Chr(34) & "urn:schemas:httpmail:displayto" & Chr(34) & " LIKE '%;%'" _ & " AND " & Chr(34) & "urn:schemas:httpmail:displaycc" & Chr(34) & " = ''" Dim strScope As String strScope = "'Sent Items'" Dim objSearch As Search Set objSearch = Application.AdvancedSearch(Scope:=strScope, Filter:=strDASLFilter, _ SearchSubFolders:=True, Tag:="SearchFolder") ' Save the search results to a searchfolder objSearch.Save (strSearchFolderName) Set objSearch = Nothing Exit Sub Err_CreateSearchFolderForOneRecipient: MsgBox "Error # " & Err.Number & " : " & Error(Err) End Sub
Macro is a modified version of code from How to create an Outlook search folder using VBA
You will have to use the Advanced Find option (CTRL+SHIFT+F) in the sent to put
Then you need to go in the advanced tab on the right where you will need to define another criteria:
The field would be
The conditioner will be
The value will be
Note the quotes around the names as it will make the difference.
Now when you hit search you will now see all emails sent to only
It's pretty easy. Select 'Sent' on the left pain. Above the list of emails click the drop-down and select "By: To" to reorder by recipient. Scroll down and find the set of emails just 'To' the required recipient. Click the bar to show the emails. You can now select the emails you need holding down shift or command then File > Print > PDF for example.
from:"Your Name" to:"Zeev" AND NOT to:"john"
The link below is a reference to instant search terms and operators:
Just follow the following instructions to complete your job...
1. Open Outlook 2010.
2. Click on 'Sent Items' at left side panel.
3. Click on Search box in the middle panel. Result: You will see the ribbon tool bar changed to 'Search'.
4. Click on 'More'(+ icon in Green colour).
5. Select 'To' from the list.
6.Enter the mail ID in 'To' field to search what are the mails you have sent to a particular person.
I could not add an image due to my reputation score crisis. Sorry for that!!