|
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("name1@company.com", "name2@company.com", "name3@company.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!
-- Related newsletter articles:
2008/04/24 Text from MS Word to MS Excel Quickly (ms excel)
2008/03/13 More or Less in MS Excel (ms excel)
2008/02/22 Microsoft Reveals Its Source (open)
2007/12/17 Add Autonumbering to your MS Excel Spreadsheet (ms excel)
2006/04/07 Missing WordPad?, Part 2 (open)
2005/02/09 Answers.com: 1-click answers to 1 million topics at your ... (alt)
2007/10/16 Reading, Editing & Forwarding a Note in Outlook (open)
2006/05/05 Email attachment reports No File Association? (open)
2008/04/14 Yahoo! Rejects Microsoft Again (enter)
2007/02/13 New Excel Attack Threatens Office (excel)
2008/01/22 Microsoft Reveals Excel Security Risk (excel)
2007/05/31 Setting File Level Protection in MS Excel (open)
2006/01/11 Power AutoPlay Menu Creator Review (open)
2005/08/02 Meta Commander File Manager Pro Review (open)
2007/05/17 Microsoft's Latest Fiasco: Reader Response (ms)
2006/07/13 MS Excel Security Leaks Becoming Flood (excel)
2007/07/18 Going to Court for iPhone Freedom (open)
-- Recent articles (from all channels): 2008/05/15 Today in History: for Thursday, May 15, 2008
2008/05/15 [ShellX 20080515]: 'Commercial Games Released As Freeware', and '
2008/05/15 Outside Company Offers Smarter Wikipedia Searches
2008/05/15 Microsoft-Google Battle Goes Galactic
2008/05/15 Find it Over and Over Again in MS Word
2008/05/15 Hackers Find A New Hiding Place for Rootkits
2008/05/14 [ShellX 20080514]: 'Blend', and 'Dexpose2'
2008/05/14 Windows XP Service Pack 3 Gives Boot to HP, AMD Machines
2008/05/14 Stephen Colbert Among 'Webby' Winners
2008/05/14 Irony Strikes At Tech Conference
2008/05/14 Getting Closure in MS Outlook
2008/05/13 [ShellX 20080513]: 'Drive Spacio', and 'Youtube Batch Downloader'
2008/05/13 Congressman Calls For Second Life Ban In Schools
2008/05/13 Trying to Exit MS Excel 2007
2008/05/13 Problems Reported With Windows XP SP3
2008/05/12 [ShellX 20080512]: 'Remote Manager', and 'Cyber Bandwidth ...
2008/05/12 Video Gaming Trade Group Struggling
2008/05/12 T-Mobile Finally Joins 3G Phone Race
2008/05/12 Apple Slammed by Environment Watchdog
2008/05/09 [ShellX 20080509]: 'Advanced Run', and 'Diver Windows Manager'
2008/05/09 Texas Refuses Facebook Friend Request
2008/05/09 Photo-Enforcement Technology Replaces Officers On Patrol
2008/05/09 Cuban Government Says 'Ok Computer'
2008/05/09 Excel Can E-Mail Your Weekly Reports For You!
2008/05/08 [ShellX 20080508]: 'Shell Enhancer', and 'Lansweeper'
2008/05/08 Xobni: MS Outlook Social Networking Technology for your Inbox
2008/05/08 Music Companies Jump on GTA IV Bandwagon
2008/05/08 Fascinating: Memristor to replace Binary
2008/05/08 Adobe Hopes To Make Flash Master Of The (Mobile) Universe
2008/05/08 Spiffy Envelopes and Labels in MS Word
2008/05/07 [ShellX 20080507]: 'Winbin2iso', and 'Loop Typer'
|
