In order to achieve this, you would need to either implement NPrinting, or alternatively use your QlikView app to extract your dataset to a .txt file, then use a third party solution such as SSIS+SSRS+Data Driven Subscription to create an excel grid and send it by email.
Yes you can do it with a QlikView macro. And the macro can be run by using Windows Task Scheduler to execute qv.exe (QlikView Desktop) daily with the /v switch to set a variable on start which can indicate to the QlikView app that you want a particular macro to be executed. You will have to set a macro to execute on open for the app. You will also have to make the macro close the app and exit qv.exe after the export.