I have never worked with this kind of programming before so here goes my problem statement ,Every hour I will receive emails from a particular sender with a constant subject for which I have created a folder under inbox called "hourly report". I need to import the body of its email received at around12.02 AM daily to my shared excel workbook(.xlsm). The body of the email is in comma seperated format as shown below.
PLACED ORDERS:
=============
DATE, HOUR, ORDERCOUNT, ORDERTOTAL
2020-12-10, 0, 0, 0
2020-12-09, 23, 18, 13
2020-12-09, 22, 29, 18
2020-12-09, 21, 25, 1
2020-12-09, 20, 29, 179
2020-12-09, 19, 25, 189
2020-12-09, 18, 30, 2
2020-12-09, 17, 35, 329
2020-12-09, 16, 22, 1
2020-12-09, 15, 35, 23
2020-12-09, 14, 37, 222
2020-12-09, 13, 29, 22
2020-12-09, 12, 32, 26
2020-12-09, 11, 45, 32
2020-12-09, 10, 25, 21
2020-12-09, 9, 26, 12
2020-12-09, 8, 12, 76
2020-12-09, 7, 14, 83
2020-12-09, 6, 10, 76
2020-12-09, 5, 3, 11
2020-12-09, 4, 3, 17
2020-12-09, 3, 9, 87
2020-12-09, 2, 5, 42
2020-12-09, 1, 9, 57
UPDATED CARTS:
=============
DATE, HOUR, CARTCOUNT, CARTTOTAL
2020-12-10, 0, 2, 2
2020-12-09, 23, 21, 1490
2020-12-09, 22, 8, 164
2020-12-09, 21, 29, 102
2020-12-09, 20, 24, 94
2020-12-09, 19, 20, 828
2020-12-09, 18, 23, 8898
2020-12-09, 16, 24, 9448
2020-12-09, 15, 90, 1249
2020-12-09, 14, 400, 14
2020-12-09, 13, 37, 88
2020-12-09, 12, 208, 838
2020-12-09, 11, 22, 9
2020-12-09, 10, 230, 8
2020-12-09, 9, 30, 742
2020-12-09, 8, 29, 86
2020-12-09, 7, 166, 753
2020-12-09, 6, 11, 4370
2020-12-09, 5, 51, 1791.4
2020-12-09, 4, 47, 173
2020-12-09, 3, 54, 3137
2020-12-09, 2, 69, 3118.65
2020-12-09, 1, 03, 47
PRODUCTS COUNT:
==============
4