Hi,
I have a table of 213 rows (with may change in the future)

Every row needs to be grouped together depending on a value in column G. (Which I can do using the Sort function)

However, the problem is, once the grouping is done, I then need to e-mail the data to various people using outlook.

For example
IF Column G = A (e-mail to Paul); IF Column G =B (e-mail to Gemma) etc.

There can be over 100 different types of values in Column G, so I guess I would need to use a v-look up table. But I don’t have much experience with V-look up and I am not too sure how I can make it so that only each value gets e-mailed to the right person.
I also can’t let person who gets value A information get value B information either.

If anyone could help me, it would be very much appreciated
I hope I have explained this ok, but if you need me to explain further let me know, I can also attached a copy of the spreadsheet if needed.
Thanks in advance
Rob