Excel Automation via VB to fetch if Outlook Email is received or not

Occasional Contributor

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

ClientErrorWarning
Client name1
Client name2

 

EXCH 

ClientUptimeDAG Errors
Client name1
Client name2

 

DFSR

ClientEmail 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

@AQureshi1709 

It may not be the vba solution you're looking for, but you might explore using PowerQuery to fetch data from Outlook:

 

Patrick2788_0-1666623057176.png