How to create an "OR" condition instead of an "AND" condition
in [Outlook]
|
From: Robert Judge on 14 May 2010 09:48 In Outlook 2007, I would like to create a filter using an OR condition instead of an AND condition. For example, I know how to create a filter that will show me all of my contacts who live in "Boston" AND have the last name "Smith." However, I want to create a filter that will show me the contacts that live in "Boston" OR have the last name of "Smith." How can I accomplish this? I will appreciate advice.
From: Bob I on 14 May 2010 10:48 Two searches, one for each condition. Robert Judge wrote: > In Outlook 2007, I would like to create a filter using an OR condition > instead of an AND condition. For example, I know how to create a filter that > will show me all of my contacts who live in "Boston" AND have the last name > "Smith." > > However, I want to create a filter that will show me the contacts that live > in "Boston" OR have the last name of "Smith." > > How can I accomplish this? I will appreciate advice.
From: Robert Judge on 14 May 2010 13:32 I don't think this is what I am looking for. In Contacts, I want to choose View/Current View/Customize Current View/Filter/Advanced/Define More Criteria: Then I want to create two filters. One filter would filter in only people who live in Boston and the second filter would filter in only people with the last name of Smith. When I apply that view, I would see people who live in Boston OR have the last name of Smith. Can I do this? If not, and I must do "two searches" as you suggest, how do I create those two searches to get the results above? "Bob I" wrote: > Two searches, one for each condition. > > Robert Judge wrote: > > > In Outlook 2007, I would like to create a filter using an OR condition > > instead of an AND condition. For example, I know how to create a filter that > > will show me all of my contacts who live in "Boston" AND have the last name > > "Smith." > > > > However, I want to create a filter that will show me the contacts that live > > in "Boston" OR have the last name of "Smith." > > > > How can I accomplish this? I will appreciate advice. > > . >
From: Sue Mosher [MVP] on 16 May 2010 19:21 You'll need to activate the hidden Query Builder feature; see http://www.outlook-tips.net/archives/2004/20040927.htm. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Robert Judge" wrote: > I don't think this is what I am looking for. In Contacts, I want to choose > View/Current View/Customize Current View/Filter/Advanced/Define More > Criteria: > Then I want to create two filters. One filter would filter in only people > who live in Boston and the second filter would filter in only people with the > last name of Smith. When I apply that view, I would see people who live in > Boston OR have the last name of Smith. > > Can I do this? If not, and I must do "two searches" as you suggest, how do > I create those two searches to get the results above? > > "Bob I" wrote: > > > Two searches, one for each condition. > > > > Robert Judge wrote: > > > > > In Outlook 2007, I would like to create a filter using an OR condition > > > instead of an AND condition. For example, I know how to create a filter that > > > will show me all of my contacts who live in "Boston" AND have the last name > > > "Smith." > > > > > > However, I want to create a filter that will show me the contacts that live > > > in "Boston" OR have the last name of "Smith." > > > > > > How can I accomplish this? I will appreciate advice. > > > > . > >
From: Bob I on 17 May 2010 12:14 OH, in that case, plug in the 2 criteria on the Advanced tab and then click SQL tab, check the box for "Edit these criteria directly" and change the "AND" to "OR". Robert Judge wrote: > I don't think this is what I am looking for. In Contacts, I want to choose > View/Current View/Customize Current View/Filter/Advanced/Define More > Criteria: > Then I want to create two filters. One filter would filter in only people > who live in Boston and the second filter would filter in only people with the > last name of Smith. When I apply that view, I would see people who live in > Boston OR have the last name of Smith. > > Can I do this? If not, and I must do "two searches" as you suggest, how do > I create those two searches to get the results above? > > "Bob I" wrote: > > >>Two searches, one for each condition. >> >>Robert Judge wrote: >> >> >>>In Outlook 2007, I would like to create a filter using an OR condition >>>instead of an AND condition. For example, I know how to create a filter that >>>will show me all of my contacts who live in "Boston" AND have the last name >>>"Smith." >>> >>>However, I want to create a filter that will show me the contacts that live >>>in "Boston" OR have the last name of "Smith." >>> >>>How can I accomplish this? I will appreciate advice. >> >>. >>
|
Pages: 1 Prev: easy to use templates Next: can't view pictures or graphics that are received |