Automatic Mail using VBA

[Ram Chandran]

Hi Guys,

I need a automatic outlook mail alert when one particular mail not received hourly. I need to alert mail regarding missing hour.
Anyone pls help me sort out using VBA or any other possible way.

Thanks & Regards
Ramachandran

 

[vletm]

How do others know:
which one particular mail is missing?
when has ... one hour ... started?

 

[jawaharprm]

Hi,
U can work on this in Power Automate.
you can this link it may useful
https://learn.microsoft.com/en-us/power-automate/email-overview

Power Platform Community Forum Thread Details

in this too u need to give the particular mail id, time line,
or you can check with abt this types more in this link

https://community.powerplatform.com/forums/thread/?discussionforumid=2f41e23c-6bd1-f011-bbd3-000d3a53db70

 

[troywest]

You can do this by running a small VBA macro that checks your Inbox every hour and looks for the specific email within the last 60 minutes. If no message is found, the macro can automatically send an alert email. If you’re using Microsoft 365, an easier and more reliable option is to create a scheduled flow in Power Automate to check hourly and send an alert if the email is missing.