Oct 23 2022 04:58 PM - edited Oct 23 2022 05:31 PM
Hi All,
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.
AD
Client | Error | Warning |
Client name1 | ||
Client name2 |
EXCH
Client | Uptime | DAG Errors |
Client name1 | ||
Client name2 |
DFSR
Client | Email Found/Not Found |
Client name1 | |
Client name2 |
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.
Please find the Excel sheet on the below link:
Regards,
Arbaz Q
Oct 24 2022 07:51 AM
It may not be the vba solution you're looking for, but you might explore using PowerQuery to fetch data from Outlook: