Peter, as of now your code sends the entire dues to all the emails in column F. Are you saying that you want to change the code to send these individually, and the move it to the summary sheet one by one?