scotsrule08
New Member
- Joined
- Jun 21, 2018
- Messages
- 45
Good day friends!
I have a large worksheet that I need to filter column B and email the filtered results to a specific contact based on the cell value.
For example
Column B:
Banana
Orange
Strawberry
Orange
Strawberry
Banana
With all results with "Banana" in column B, email rows A:J to john@gmail.com
With all results with "Orange" in column B, email rows A:J to suzie@yahoo.com
etc....
Thank you!
I have a large worksheet that I need to filter column B and email the filtered results to a specific contact based on the cell value.
For example
Column B:
Banana
Orange
Strawberry
Orange
Strawberry
Banana
With all results with "Banana" in column B, email rows A:J to john@gmail.com
With all results with "Orange" in column B, email rows A:J to suzie@yahoo.com
etc....
Thank you!