Thank you for this. Excellent code examples. I would like to create a Form next - so I can select different search patterns and then run the code against the selections. Thank you again.
Hi Thank you for the very good video and links. How would the strfilter look like if you would like to choose a string instead of typing the searchword in the code itself?
Thanks Jenn it is very help full I got one challenge I need to search keyword in the PDF attachment files. I have tried but not able find the solution Please provide if there is any way
Hi, helpful video. I want to actually filter the outlook folder with the resulting emails (preferably just the unreads, but that's not as important). Do you know how to not just get the matching emails into a debug window but to actually have the resulting emails filtered (just like if i had typed Subject: Developer in the search box in outlook)?
Think that will work but just search from the latest mail to the oldest instead of the default oldest to latest will also work and maybe easier or not?
Good work and Great Video... I actually wanted to select all the emails received on today's date but not for the other dates. Can you please post a video for selecting all email for today's date and copy & pasting the subject lines to the notepad?
It is possible, but different criteria with different fields require different filter setup. Usually you will have to define your criteria first then create the filter accordingly.
Hi Thank you so much for the information. I have a requirement user has to provide the serching key words. When I am trying to give like this i am getting error as " Cannot parse conditions. Error at "@SQL="urn:schemas:httpmail:textdescript..... I have mentioned as Filterstring = "@SQL=""urn: schemas: httpmail:textdescription" & Sheet1.Range("A1").value User input: In A1 = "Like '%Hi Lyndy%'" If you can suggest me it would be very helpful
Thank you for this. Excellent code examples. I would like to create a Form next - so I can select different search patterns and then run the code against the selections. Thank you again.
Hi. Thanks for the tutorial. I can see that you have two accounts. How do you select the one you want to search in the inbox folder?
Can you use multiple wildcard feature you mentioned? I.e. Search multiple words in the same line.
Hi
Thank you for the very good video and links.
How would the strfilter look like if you would like to choose a string instead of typing the searchword in the code itself?
Thanks. Do you know how we can open a specific email via its ID (GUID or conversationID or something like that) from excel using VBA?
I need to automatically reply all with a custom message like "Please proceed" if i receive an email with specific word in subject. Is this possible?
Thanks Jenn it is very help full
I got one challenge I need to search keyword in the PDF attachment files. I have tried but not able find the solution
Please provide if there is any way
Hi, helpful video. I want to actually filter the outlook folder with the resulting emails (preferably just the unreads, but that's not as important). Do you know how to not just get the matching emails into a debug window but to actually have the resulting emails filtered (just like if i had typed Subject: Developer in the search box in outlook)?
Think that will work but just search from the latest mail to the oldest instead of the default oldest to latest will also work and maybe easier or not?
Good work and Great Video... I actually wanted to select all the emails received on today's date but not for the other dates. Can you please post a video for selecting all email for today's date and copy & pasting the subject lines to the notepad?
I will look into it.
Hi, great video thanks!
Do you know if it is possible to restrict the subject, the textdescription, and the lastupdatetime all at once?
It is possible, but different criteria with different fields require different filter setup. Usually you will have to define your criteria first then create the filter accordingly.
Brilliant
Hi Thank you so much for the information. I have a requirement user has to provide the serching key words. When I am trying to give like this i am getting error as " Cannot parse conditions. Error at "@SQL="urn:schemas:httpmail:textdescript.....
I have mentioned as
Filterstring = "@SQL=""urn: schemas: httpmail:textdescription" & Sheet1.Range("A1").value
User input:
In A1 = "Like '%Hi Lyndy%'"
If you can suggest me it would be very helpful
This is most likely some special characters are not interpreted correctly by VBA.