Hello everyone,

After days of failing, I have come here to ask for your help gurus please!!

I am working on a VBA project in Excel that involves three main tabs:

Mailing: This tab contains a table with client names and emails. I have a button that allows sending emails to all clients listed in the table. This part is working perfectly!!!.

Followup: In this tab, I want to retrieve the 100 most recent emails from my inbox and fill them into a table. The goal is to read these emails and compare them with the emails sent from the “Mailing” tab to check if I have received responses from my clients.

Inbox: This tab serves as a database where the 100 most recent emails are stored. This is working as well!!

What I need:

WORKING – Retrieve the 100 most recent emails: I need help writing a VBA code that retrieves the 100 most recent emails from my Outlook inbox and fills the “Inbox Emails” tab.NOT WORKING – Compare and update status: After filling the “Inbox Emails” tab, I need the VBA to read each of the 100 emails and compare them with the emails sent listed in the “Mailing” tab. If there is a response from a client, the status should be updated to “New Answer”. If there is no response, the status should be “Waiting”.

I appreciate any help in advance and am available to clarify any questions. Please reach to me in any platform!

​Hello everyone,After days of failing, I have come here to ask for your help gurus please!! I am working on a VBA project in Excel that involves three main tabs:Mailing: This tab contains a table with client names and emails. I have a button that allows sending emails to all clients listed in the table. This part is working perfectly!!!.Followup: In this tab, I want to retrieve the 100 most recent emails from my inbox and fill them into a table. The goal is to read these emails and compare them with the emails sent from the “Mailing” tab to check if I have received responses from my clients.Inbox: This tab serves as a database where the 100 most recent emails are stored. This is working as well!!What I need:WORKING – Retrieve the 100 most recent emails: I need help writing a VBA code that retrieves the 100 most recent emails from my Outlook inbox and fills the “Inbox Emails” tab.NOT WORKING – Compare and update status: After filling the “Inbox Emails” tab, I need the VBA to read each of the 100 emails and compare them with the emails sent listed in the “Mailing” tab. If there is a response from a client, the status should be updated to “New Answer”. If there is no response, the status should be “Waiting”.I appreciate any help in advance and am available to clarify any questions. Please reach to me in any platform!   Read More

​