How Do I Automate Stored Procedure, Then Its Result Should Be Stored In Excel Sheet automatically and Is Attached In An Email And Send At A Particular Time Automatically

You could use Windows Service. A different approach would be by using PowerShell scripts. These scripts can be executed periodically very easily by firing up scheduled jobs for windows (maintenance tasks).
You're able to connect to the database, execute the sproc, retrieve the result. Convert it via script. Use Excel Interop Assemblies probably to convert it directly to XLS (or use pipe out to generate proper CSV files).

Use another script to grab the new output files (check or keep log if file already has been handled in the past) which is started by Windows scheduled job (execute .ps script) and send mail via intranets SMTP (or use SqlMail).

Nice task indeed.