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
  • PrintPrint
Share this Page URL
Help

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


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint