As the title suggests, I have been working on this for 2 days and am unable to find a solutions that works. I have an excel spreadsheet that tracks the progress of tests people need to take/have taken. I have all of the data in A10-A40 (names) and B10-B40 (% complete). I would like to email the data from these 2 sections of information to a list of people that never changes (so it can be defined in the macro). Any help would be greatly appreciated. Thank you in advance.