I currently have a macro that sends out emails automatically based on the parameters I have set in my code. My spreadsheet contains multiple recipients. Often times a recipient may be listed more than once. Currently, my macros runs line by line where each row that meets my parameters gets an email to the linked recipient. If I have one recipient who is listed multiple times, this person will get more than one email. Before I automated this process, emails were sent out manually. If a recipient was listed more than once each row was combined into a table so they would only get one email. Is it possible for my recipients who are listed more than once to get Only one email rather than multiple using vba?