|re: it sends an email to all the users who were affected by a change in names from a dropdown list.|
That was the part that was not clear. It appeared from your earlier posts that you were making one change, and you wanted to go from 1 email (new name) to 2 emails (new and old). You have now made it clear that you want to send emails to multiple new names and multiple old names. That's very different.
re: I think you understand what I'm trying to accomplish
Please keep in mind that I can not see your workbook from where I am sitting, nor can I read minds. I can only go by what you post in this forum, so if it is not clear to me what you are doing, all I can do is keep asking questions until I understand it all.
So, let me tell you what I do understand so far, and what is still not clear to me. Without a complete understanding of how the workbook is set up and how you are using it, I can't possibly offer a solution.
1 - You have a list of names in Column A
2 - You have a list of corresponding email addresses in Column B
3 - You have IF functions in Column C
4 - You have multiple Drop Downs in Column E, populated with the names from Column A
5 - When you select a name from a Column E Drop Down, the IF functions in Column C place "Yes" next to the email address for the person selected in the Drop Down.
6 - After you have selected all the names that you want to, you run the macro and the emails get sent to any email address with a Yes next to it.
Please let me know if those steps are correct.
Here are a couple of assumptions that I am making based on the steps above.
After you run the macro, I assume the Yes's are still in the cells next to the email addresses to which the emails were just sent. I further assume that each time you change a name, an old Yes goes away, because the name is no longer is selected in a Drop Down and the IF function "removed" the Yes. At the same time, the IF places a Yes next to the new name that was chosen.
Please let me know if those assumptions are correct.
What is not clear to me is how the new chosen name relates to an old name or whether that even matters. For example, let's keep it simple and say that you have 2 names chosen and 2 emails have been sent. Let's say you chose Bob and Sue, therefore Bob and Sue have Yes next to their email addresses.
You now want to change Bob to Fred and change Sue to Ann. Does is matter that Bob was changed to Fred and Sue was changed to Ann or do you simply want emails - the same email - sent to all four individuals? In other words, are the changes "paired up" new-to-old or are they nothing more than a bunch of unrelated names and all four of them should get an email?
I'm also not clear on whether or not the Drop Downs are lined up next to each name or if they are basically unrelated.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.