Auto update VBA on opening. send to Outlook

Good day to everybody.
new user here.

i am sharing file here, since for some reason i cannot attach it
docs.google.com/spreadsheets/d/1OVY6q8PU2hl27alBVxeDcDKyVfxE1hfb/edit?usp=sharing&ouid=103656479342250674299&rtpof=true&sd=true

Please Login or Register  to view this content.

I am trying to make this code run so every time I open it so excel automatically checks for expired equipment, put message about it and then send it to Outlook.
Ideally i want all outdated equipment to be listed in email too.

i tried to copy the code to Workbook section and insert it here but it is working.

Please Login or Register  to view this content.

is there any way around it?
p.s. I know it is bad code, it could be improved, but currently I am limited to my knowledge.

thank you sir. unfortunately Outlook window does not show up at all.

to make clear i want days counts to be checked(E column), and then names(A column) shown in Outlook

Originally Posted by k1dr0ck

your range is up to 10,000 rows
do you want to include all the equipment name which are overdue in the subject in one email?

i put range just in case. i will reduce it to hundreds later when working with real numbers of our equipment.

Yes, correct, include all overdue equipment in email body and preferably place message box in excel, stating generally that there is expired equipment detected

try

Please Login or Register  to view this content.