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 |