Macro Send Email & Set Reminder From Excel. The Excel software allows you to use the VBA coding language to create macros and automated services.

Can Excel send Alerts? Yes, but with some limitations. Excel cannot email an alert to you automatically unless you write a macro in the Visual Basic (VBA) editor to perform this function.

If the boss wants to review a Microsoft Excel report every day at the same time, don't worry: You can use a Power Automate flow to automatically send that report on time.

Click the "Office" button in the top left corner of the Excel window, select "Send" from the resulting drop-down menu and click "E-mail." A Microsoft Outlook window appears.

Follow these steps to have Excel e-mail the reports for you. If you have to send the same worksheet to a number of people every week, it probably takes you quite awhile to prepare the e-mail.