Forum Discussion
Excel Automation via VB to fetch if Outlook Email is received or not
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:
https://easyupload.io/8b9xab
Regards,
Arbaz Q
1 Reply
It may not be the vba solution you're looking for, but you might explore using PowerQuery to fetch data from Outlook:
