使用VBA Excel / Outlook每个工作日发送刷新的Excel工作表

Every day at 3PM I have to send out an Excel Workbook to a colleague. The macro in the workbook simply copies all cells in one sheet and Paste Special to another sheet and saves the workbook. I have written the macro to do this and also to send it to an email address, however I struggle to have it sent automatically. I have instructed Scheduling Tasks already, but I don't know how to make the link between opening Excel, performing the Marco, saving the workbook and sending it to a specified person. Code is below - thanks for you help.Every day at 3PM I have to send out an Excel Wo