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.

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.