Re: How to auto send email, from multiple sheets, it works on one not on multiple

[nje]

In the attached sample file, the auto email sender works when the book is first opened, but only when there is just one sheet in the workbook with emails to be sent.
I really want it to work when there is more than one sheet with emails to be sent out, it will end up with about 10 sheets in total.
The sheets will be similar but with different data, but all the dates in the same column.
I haven't got a clue how or if this can be done, I don't think this is an easy problem to solve but I would appreciate any help or advice on how to solve it, if it's possible.

Thank you