Excel Can E-Mail Your Weekly Reports For You!
Many times, in an office setting, you have an Excel spreadsheet that has to be sent to different departments on a weekly basis. Even if you have a distribution list setup in MS Outlook, it still takes some time to setup your e-mail and proof it before sending it out. Why not let MS Excel do it for you?
Follow the steps below to lighten your workload:
- Launch MS Excel if it is not already open.
- Open the workbook containing the report you want to send.
- Click ALT + F11.
- The Visual Basic Editor will open.
- In the Project-VBA Project pane, double-click ThisWorkbook.
- Go to Insert | Procedure.
- Click in the Name text box and enter WeeklyReportEmail.
- Click OK.
- At the prompt, enter the code below:
- Dim DistList As Variant
- DistList = Array("email@example.com", "firstname.lastname@example.org", "email@example.com") ActiveWorkbook.Sendmail Recipients: = DistList
- Click ALT + Q.
- Click ALT + F8.
- Click WeeklyReportEmail in the Macro list.
- Click the Options button.
- In the CTRL+ box, enter m.
- Click OK.
When it is time to send the spreadsheet to everyone on your distribution list you simply open the workbook and click CTRL + M.
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
Free guide: Windows 7 -- Free Quick Reference Card. Ask any pro computer user and they'll tell you: having to constantly reach for the mouse not only causes strain on your neck and back - it also slows you down. Imagine being able to control your computer the way it was meant to be - using your keyboard! With this guide, you'll learn to dramatically increase productivity using the best ways to navigate, organize, and manage your Windows PC and its contents. Most importantly: the majority of these shortcuts, tips, and tricks are valid for any PC, netbook, and laptop running Windows XP, Vista, and 7. Use it to brush up on the basics and to find alternate methods to your favorite commands. This printable quick reference guide is yours to use, distribute, and share! Click here to download this guide now! Note: this guide is free, but registration is required; after that, you can select more ebooks and videos for download without registering again. If you have questions / problems with the registration form, please read this.