Hi
I have a table like below. I want to filter by Agent Name (agent1, agent2, agent3) and then after filtering by name, I want to send the result by email to that person. For example, I want to filter column 3 by agent1, then I sent the result to agent1@abc.com, and I do the same thing for agent2 (agent2@abc.com) and agent3. So these agents wont see each other info. I can create a slicer to filter by agent but then how to email. I was thinking about inserting button and then email (vba) but I have not idea how to do that. Would appreciate any help. Thank you.
I have a table like below. I want to filter by Agent Name (agent1, agent2, agent3) and then after filtering by name, I want to send the result by email to that person. For example, I want to filter column 3 by agent1, then I sent the result to agent1@abc.com, and I do the same thing for agent2 (agent2@abc.com) and agent3. So these agents wont see each other info. I can create a slicer to filter by agent but then how to email. I was thinking about inserting button and then email (vba) but I have not idea how to do that. Would appreciate any help. Thank you.
| Customer Name | Store | Agent Name |
| Mary | StoreA | Agent1 |
| Alex | StoreB | Agent2 |
| Adam | StoreA | Agent1 |
| Sara | StoreC | Agent2 |
| Anna | StoreD | Agent3 |
| Dany | StoreA | Agent1 |
| Sam | StoreA | Agent2 |
| Anna | StoreB | Agent1 |
| Anna | StoreA | Agent2 |
| Lynn | StoreC | Agent3 |
| Liz | StoreD | Agent1 |
| Jack | StoreA | Agent2 |
| Mike | StoreA | Agent1 |
| Linda | StoreB | Agent2 |
| Sandy | StoreA | Agent3 |
| Eva | StoreC | Agent1 |
