VBA code to delete emails after a pre-defined mailbox size is reached

[Abhijeet R. Joshi]

Hi there,

I am looking for potential solution to one of my problems:

Problem: Huge mailbox sizes which need to be reduced.
Idea: create a VBA code to automatically delete the oldest emails from said folders once the overall mailbox size reaches 30GB, deleting emails from archival folder should do as well.
Caution: Before executing the macro it should ask for permission since deleting huge emails would disable other events and that should not hamper the current work.

Thanks a lot for your help in advance !