For now, I only need someone to help with the VB code where I can fetch data from Outlook and check if the email is received or not in the folder for the particular client mentioned in the DFSR Clients sheet.
I already have an Excel Automation Sheet. Where we have a Fetch Data button with time(in minutes)
Once we enter the time the sheet Fetches data from Outlook's (Sub Folder i.e AD Health Report, Exchange Server Health, and DFSR Report)
We have other sheets named AD Clients, DFSR Clients, and Exchange Clients.
Email Found/Not Found
When the Data Fetching has been completed, it informs us if the emails have any failure in the report or not for AD and EXCH. DFSR doesn't work
AD and EXCH module works fine, but DFSR does nothing.