EXCEL VBA - Problem to search an email in Outlook folder

[gkumthekar]

Hi All,

I have a code for EXCEL VBA that searches for email messages in certain folder of Outlook ( both 2007 version). However, the comparison starts from the lastest email in the folder and not from the first email. ( in Outlook, I prefer to keep the email messages sorted as Newest first and would like to get the first email that matches the subject line provided.

Can you please help me reverse the order in which the EXCEL VBA is searching for the email? Below is the code:

Please Login or Register  to view this content.

Thanks in advance for help.


Regards,
Ganesh K

[gkumthekar]

Solved it somehow...

Please Login or Register  to view this content.

For me, this is checking if there are any replies for that email as well and opens the newest email for the reply.

[arlu1201]

Welcome to the forum.

I have added code tags to both your posts. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.