VBA code required to capture subject date and time from outlook email

[exceluser9]

Hi Team,

We do receive 3 auto generated emails from system from email@automate.com

Below are the email subjects

GPRS System Availability ETA - 08:53
GPRS System Availability ETA - 09:15
GPRS System Availability ETA - 09:16

What i want the macro to do is copy and paste the email subject, email time in the excel file in below format

On Monday when i run the macro it has to capture the data for Saturday, Sunday & Monday because on weekends we dont work.

Please note on Sunday i receive only one email so the data can be blank for rest of the 2 rows

The calendar date in the file will be update by us. Macro has to capture only subject and time and paste the data for the respective dates

Whenever i run the macro the macro has to paste only the missing data for respective dates for the data which is already captured it can ignore

Thanks in advance

Sample grid below

Calender date	Subject	Email time
10/1/2023	GPRS System Availability ETA - 08:53
10/1/2023	GPRS System Availability ETA - 09:15
10/1/2023	GPRS System Availability ETA - 09:16
11/1/2023
11/1/2023
11/1/2023
12/1/2023
12/1/2023
12/1/2023
13/1/2023
13/1/2023
13/1/2023
14/1/2023
14/1/2023
14/1/2023