User Profile
Leozin28
Copper Contributor
Joined 6 months ago
User Widgets
Recent Discussions
Followup sheet - Macro
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!408Views0likes2Comments
Groups
Recent Blog Articles
No content to show