i am using the below code to open and email and add the recipient based off cell values. I have been working all day to try to find a way to open 7 of the same emails but have them addressed to different people with one macro.
any tips?
thanks in advance!
Sub Rectangle1_Click()
Sub Mail()...