I have a huge list that has name, number, dept, e-mail, and many columns with different projects, etc. Each person has marking in various columns, depending on which one they are on.
I am looking for a method to allow me to filter this huge list down to a smaller specific list (like for people only on a particular project or system, or just managers, etc), then at the top of the column that has everyone's e-mails I want to have a button to send an email to just those people that I filtered down to.
The file in this link does almost exactly what I want, except for being able to send an e-mail to only the rows that are actively shown after being filtered. I tried adding a bunch of e-mails, then in the 4th column, put a mark on a few rows, then filtered to just those rows. When I click the e-mail button, it prepares an e-mail for the entire list, not the filtered list.
https://chandoo.org/wp/send-mails-using-excel-vba-and-outlook/
For my purpose, I also deleted the code that prepares sending a file. I do not need that functionality.
Any help is appreciated.
Thanks,
Tom
I am looking for a method to allow me to filter this huge list down to a smaller specific list (like for people only on a particular project or system, or just managers, etc), then at the top of the column that has everyone's e-mails I want to have a button to send an email to just those people that I filtered down to.
The file in this link does almost exactly what I want, except for being able to send an e-mail to only the rows that are actively shown after being filtered. I tried adding a bunch of e-mails, then in the 4th column, put a mark on a few rows, then filtered to just those rows. When I click the e-mail button, it prepares an e-mail for the entire list, not the filtered list.
https://chandoo.org/wp/send-mails-using-excel-vba-and-outlook/
For my purpose, I also deleted the code that prepares sending a file. I do not need that functionality.
Any help is appreciated.
Thanks,
Tom