I m now learning vba now but cant solve my issue at work
What I want to do is ...in one of my excel worksheet , in column G, for any cell value G1, going down, G2, G3 and loop to G20 ...if the value in G1 is greater than >= 10, I will copy A1:E1 to Microsoft outlook with value and original format, send to email@example.com with email heading "Error"
same token in G2 if value >=10, copy A2:E2 to outlook....etc
I hope I can set the daily timer at 15:45:00 to run this macro
I m really appreciated if someone here can do me a favor