If value is >= 10 then send Outlook mail [Closed]

Report
Posts
1
Registration date
Wednesday August 29, 2018
Status
Member
Last seen
August 29, 2018
-
Hello,

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 a*******@gmail.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

Best

Andrew