Hi
so I was working on a stats report for my office. The macro is able to send out 20 emails to each staff for their weekly performance. Right now there are 14 staff, but the macro would only sent 12. Also, I'm a beginner in excel macro, so my code is very long. I was hoping to reduce it, but not sure how to use the Loop for Range. Hopefully someone can help me. Thanks
Bookmarks