Outlook 2007 Criteria Search

Status
Not open for further replies.

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
The following code searches the field with the certain name in the field. Can I add to this macro how it searches that field and another field that has nothing it that other field?

Sub SearchByTopFollowUpNextStepTalk()
Dim myOlApp As New outlook.Application
txtSearch = "[TopFollowUpNextStepTalk]:(Top)"
myOlApp.ActiveExplorer.Search txtSearch, olSearchScopeAllFolders
Set myOlApp = Nothing
End Sub
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Any update please. And so you know, these fields were created for the contact form and I would like to search more than one field so if the first field has a word in it, and the next field as not words in it, it will show the contacts that those fields are set up for those contacts. So another field name is TopFollowUpNextStepTalkMeet.

And again, here is the macro to upgrade if that is possible which I need right away.

Sub SearchByTopFollowUpNextStepTalk()
Dim myOlApp As New outlook.Application
txtSearch = "[TopFollowUpNextStepTalk]:(Top)"
myOlApp.ActiveExplorer.Search txtSearch, olSearchScopeAllFolders
Set myOlApp = Nothing
End Sub
[DOUBLEPOST=1445095513][/DOUBLEPOST]And when I post the macro before the last word Top, is shows that picture...which is not the code....before the last word Top is the : (
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
No. I want to find contacts if the contact has the value in field1 and field 2.
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
So what do we add to the macro so it also searches the other field and the same time?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Put the two strings together with an AND -
txtSearch = "[TopFollowUpNextStepTalk]: (Top) AND [Field2] : (Whatever)"
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
And as to field 2, I stiil want to see the contact if the field2 is no words. So as to field 2, do i show in the macro as just ( ). ??
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Try it - not sure it will work though. Do all contacts have that field?
 

LMS

Senior Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Yes. All contacts have all my fields as the fields are in the contact form
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
If they all have it, try using ("") for the search. If you are looking for a value or blank use ("value1" OR "").
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
S Verwendung von Outlook 2007 Using Outlook 0
A Arthur needs help with 2007 Outlook e-mail Using Outlook.com accounts in Outlook 3
M PST import from Outlook 2007 to 2010 - Address Book contacts all in 1 group Using Outlook 4
S outlook 2007 calendar search Using Outlook 6
B Migrate Outlook 2007 to Office 365 Using Outlook 3
X I have met my waterloo trying to resolve embedded graphics problem with outlook 2007 and now 2016 Using Outlook 1
R Outlook 2007 only loads some appointments Using Outlook 0
C Move Outlook 2007 to new PC with Outlook 365 Using Outlook 3
J Outlook 2007 Hide Messages Option not Available Using Outlook 2
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 4
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 0
B Server errors Outlook 2007 Using Outlook 1
S Reboot of frozen windows7 results in changed outlook 2007 settings Using Outlook 1
S Outlook 2007 printing wrong email address at top of page Using Outlook 8
M Configure outlook 2007 to accept digital signatures Using Outlook 2
D Outlook 2007 crashes when opening an email Using Outlook 2
R New chap saying hello and needing advice on Outlook 2007 thumbnails Using Outlook 3
icacream From Outlook 2007 to 2016 ! Using Outlook 9
vodkasoda Object could not be found Error in Outlook 2007 Outlook VBA and Custom Forms 5
S Outlook 2007: Address Cards allow entering text! Why? Using Outlook 3
S View Appointment in Text Wrap in Outlook 2007 Month Calendar View Using Outlook 0
L Outlook 2007 Separate the Send/Receive functions Using Outlook 2
M Outlook 2007 Contacts Glitch: Creating a new email Using Outlook 1
C Move from Outlook 2007 Enterprise (MOE) to Outlook Pro plus 2007 Using Outlook 1
J reinstalling Outlook 2007 asking for user name & password Using Outlook 14
P outlook addin unloaded in office 2007 Using Outlook 0
B Fonts in Outlook 2007 Using Outlook 4
R Add Exchange Account to existing POP3 Outlook 2007 Profile Using Outlook 0
C out of space in file group Outlook 2007 Using Outlook 2
A Moving archived contents in Outlook 2007 back into working folders Using Outlook 0
P Outlook 2007 Email Categorization using VBA Outlook VBA and Custom Forms 1
M Unable to Configure Gmail Account in Outlook 2007 Using Outlook 1
R Outlook 2007 or 2010 - Lock Down Functionality Outlook VBA and Custom Forms 3
S Outlook 2007, windows 10 Font size Using Outlook 1
Diane Poremsky Manually create a POP3 account in Outlook 2007 New Slipstick.com Articles 0
J Can Click to Drag Custom Form Field But Cannot Drop When Designing in Outlook 2007 Outlook VBA and Custom Forms 2
L Outlook 2007 Font Using Outlook 3
J Outlook 2007 connector and Windows 10 Using Outlook 3
R Outlook 2007 - Shared Accounts and Resources without Exchange Server Using Outlook 0
L Outlook 2007 - Macro Re Search Using Outlook 16
D Outlook (Office) 2007 & Windows 10 Pro Using Outlook 6
MattC Problem with Outlook 2007 & iCloud / duplicate tasks Using Outlook 1
D Outlook 2007 e-mail header- How to set font & font size in received message headers ? Using Outlook 2
P How to switch back from Outlook 2010 to Outlook 2007? Using Outlook 3
L Outlook 2007 Macro to Contact From a Field Using Outlook 3
A Corrupt tasks in Outlook 2007 Using Outlook 1
Diane Poremsky Outlook 2007 with Office 365? New Slipstick.com Articles 0
D Need Genuine Office or Outlook 2007 Using Outlook 3
P Outlook 2007 not sending/receiving until restart (send/receive stuck at __%) Using Outlook 27
J Outlook 2007 - Change Message Class for all Items in Folder Outlook VBA and Custom Forms 1
Similar threads


















































Top