AirAssault
New Member
- Joined
- Jul 10, 2014
- Messages
- 10
I've search the internet for what I'm needing but I've come up short.
Basically, I have a userform with a button and two textboxes. When I press the button, it should search for email subjects that CONTAINS the keyword in the txtbox1.value. Most of what I've seen on the internet is code for exact matches and not 'if it contains' a certain value.
Also, I'm trying to return results found to display in a textbox2.value. For example, If i searched for 'Air Assault' it should display in textbox2.value = "Air Assault" & vbnewline & "Air Assault 101" & vbnewline & "Air Assault Screaming Eagle" because all these emails contain Air Assault in the Subject line.
In Summary, how would you search email subjects that contain keywords based on a textbox value and then return the results in a different textbox.
Using Office 2010. I'm continuing my search and still expirementing, will post my results if a solution is found, I appreciate any help. Thanks!
Basically, I have a userform with a button and two textboxes. When I press the button, it should search for email subjects that CONTAINS the keyword in the txtbox1.value. Most of what I've seen on the internet is code for exact matches and not 'if it contains' a certain value.
Also, I'm trying to return results found to display in a textbox2.value. For example, If i searched for 'Air Assault' it should display in textbox2.value = "Air Assault" & vbnewline & "Air Assault 101" & vbnewline & "Air Assault Screaming Eagle" because all these emails contain Air Assault in the Subject line.
In Summary, how would you search email subjects that contain keywords based on a textbox value and then return the results in a different textbox.
Using Office 2010. I'm continuing my search and still expirementing, will post my results if a solution is found, I appreciate any help. Thanks!
