I have created a table that keeps up with all of the employees' time for the week. Each week, our payroll admin will print out the reports. I have the report looping based on who is selected so it generates only one person's weekly information per sheet. For example, she selects Amanda, John, and Lucas then selects week 16. She then hits "Print Weekly Report". This will print the same table, but one sheet with Amanda's time, one with John's and one with Lucas's. What I want to do is take that same method and instead of printing it out, I want to e-mail each person their weekly time sheets based on who I select. Is this possible?