Hello
I want to send a specified cell range ( a1:j20) in the body of an email automatically on specific date and time
for week 1, everyday except monday when the values are all zero for the new week
say for the range a1:j20 send email the next morning at 0230hrs from Tuesday morning 0230hrs (31/12/2019) to Monday 0230hrs (06/01/2020)
The next week a new range will be sent (n1;w20) in email automatically
for week 2
say for the range n1:w20 send emails the next morning at 0230hrs Tuesday morning at 0230hrs(07/01/2020) to Monday 0230hrs (13/01/2020)
and so on for range a23:j42, n23:w42 and a45:j64, i fugured hard dates are needed since the ranges are needed for different subsequent weeks but from the same sheet
I have cobbled some code together from some digging, I managed to get it to work manualy but only with run function manually and only then for one range
Please see attachment for current code
Thank you
Bookmarks