Guys I need help with a VBA code at my work

[antokout]

Guys I want to create a code , This code will query a subject for example "facebook" and will count how much emails received with this subject from inbox and will put these emails in specific worksheet that i create with the name "facebook" for example

 

[antokout]

Maybe i am not asking the correct question I mean that i need direction on how i can search a specific word on subject of emails in my inbox . For example the word on subject is "upgrade" and when i run code to show all emails with this subject word

 

[Logit]

.

Untested here :


https://www.excelguru.ca/forums/showthread.php?7260-Excel-vba-to-search-mail-in-outlook

 

[antokout]

I dont want to send me on outlook i want to put those emails with specific subject on worksheet

 

[Logit]

.
https://www.ozgrid.com/forum/forum/...-and-copy-the-email-body-to-excel-and-save-it

https://stackoverflow.com/questions/21549938/vba-search-in-outlook

http://www.outlookcode.com/threads.aspx?forumid=2&messageid=33943

 

[antokout]

Noone of these doing for me the first one is wrong the line InStr(olMail.Subject, “Criteria") > 0 Then and 2nd need object for Debug.Print line and 3rd talk about Outlook Vba i need Excel