I have an excel file which updates data in sheet when open. This data is pulled from sql server database.

I would like to make this automate. I want this file to be store in a location and daily morning(ex at 6 am) this automatically pulls the data from sql server(which already doing when open the file, but manual work for which we need to open the file manually) and save the file at same location and then close it and email this file to me.

is there a way out for this?