Extract a list a of data and then divide it as needed

Hello, please could u help me?
I have to extract a list of employees from a database who fulfill their job anniversary within this month, but them all are part of three different locations/states of the company.
I need to send an e-mail in the 1st day of the month which contain the list of employees of the same state to its correspondent HR department. How to can divide the first extracted list (all of them) in three ones and then send them through email to the correct HR email address (having 3 of them as per being 3 different states) .


Check this…I believe its same but differnet columns