Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 28. Working with Outlook from Excel > E-MAILING A SINGLE WORKSHEET
28.3. E-MAILING A SINGLE WORKSHEET
You can e-mail a single worksheet using SendMail with Microsoft Outlook. The following macro copies the active worksheet and sends it as the lone worksheet in its own workbook:
Sub EmailSingleSheet() ActiveSheet.Copy On Error Resume Next ActiveWorkbook.SendMail "someone@anywhere.com", "Test of single sheet" Err.Clear ActiveWorkbook.Close False End Sub
