I have started my new intern job where my first task is below..

So My data base is DB1
I have some 120 tables in that
I have one particular table which is oraganization

My job is to run a query "select * from organization"
and the results that i get, I have to send it to my email ID.. but not manually by exporting a file,

It should be automated. It’ll need to run every night automatically without anyone doing anything. Is that possible?

My work so far::
I have created a new profile and associated an account to it using database mail node in the sql server management studio

Any help is greatly appreciated..