copy past (condition) and send to outlook with timer set on daily

[klechan]

Hello,

I want to solve my issue at work via excel VBA

everyday at 15:45 PM

Open an excel file workbook in my c://path/name file say file name is Andrew_daily error

REFRESH the workbook Andrew_daily error to get the most updated information (it links up another excel data)

in the excel workbook ..Andrew_daily_error

in worsheet1...

What I want to do is ...for any value in column G, say from G1, going down, G2, G3 and loop to G20 ...if the value in G1 is greater than >= 10, copy A1:E1 and create a temp worksheet2 paste to the temp worksheet2 with value and original format then loop back to G2, by the say way for cell G2 if value >=10, copy A2:E2 to worksheet2 ...till the looping is completed

There maybe only 10 rows (looping up to G10) or there maybe 20 rows (up to G20) depending on if there is any value in G or STOP looping once G value is N/A or space empty

copy all the value in worksheet2 and paste to Microsoft outlook..send to a*******@gmail.com with email heading "Error", cc b*****@gmail.com

then SEND the outlook (the timer is set to 15:45pm)

i want to set the timer 15:45pm

After sending out the email.....

go back to excel workbook (Andrew_daily error) and Rename temp worksheet2 TAB using date today (format like Month Day Year e.g 09102018)

Save the workbook Andrew_daily error

I hope I can set the timer at 15:45:00 pm to run this VBA macro everyday

I m really appreciated if someone here can help

Best

Andrew