conditonal copy paste to outlook via excel vba

set a timer in an excel worksheet, once condition met in the worksheet1, copy and paste certain data to MS outlook and send it out everyday , back to workbook, create a worksheet2 and name it (mmddyy the date we create) save the data(we send to outlook) in the same workbook in the attached excel, if G3 >10%, copy A3:E3 to outlook again if G4>10%, copy A4:E4 to outlook loop G col for every value > 10 ...copy to outlook send outlook create a worksheet2 and save the data