SendMail Method of Workbook Object VBA

SendMail Workbook method is used to sends the workbook via an email as an attachment by using the installed mail system.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


When we use SendMail Workbook Method in VBA?

We use SendMail workbook method when we wanted to send an email to the specified recipients and workbook as an attachment. We can also send particular worksheet as workbook.

VBA SendMail Workbook Method- Syntax

Here is the syntax of SendMail workbook method in VBA.

Workbooks(“Your Workbook Name”).SendMail(Recipients,

[Subject], [ReturnReceipt])

Where,
Recipients: It is required parameter. It specifies the name of the recipient(s) and added as To recipients.
Subject: It is an Optional parameter. It specifies the subject of the message. If you don’t specify any name, Default name is document name.
ReturnReceipt: It is an Optional parameter. Default value is False. If it is True notifies the sender when recipient receives an email.

VBA SendMail Workbook Method: Example 1

Please find the below example, it will show you how to send an email using SendMail workbook method using VBA.

Sub End_Email()
ThisWorkbook.SendMail "", "Sample Workbook"
End Sub

Explanation:In the above example it will send the activeworkbook as an attachment to and subject is ‘Sample Workbook’.

VBA SendMail Workbook Method: Example 2

Please find the one more example, it will send one worksheet from a workbook.

Sub Send_Worksheet()
ThisWorkbook.Sheets(“Sheet1”).Copy
With ActiveWorkbook
.SendMail Recipients:="", Subject:="Sample Workbook"
.Close SaveChanges:=False
End With
End Sub

Explanation: It will create a new workbook with which we are copying worksheet and send as an attachment. And then finally it closes the new workbook which we created without saving.

VBA SendMail Workbook Method – Instructions

Please follow the below step by step instructions to execute the above mentioned VBA macros or codes:

  1. Open an Excel Workbook
  2. Press Alt+F11 to Open VBA Editor
  3. Insert a Module from Insert Menu
  4. Copy the above code for activating a range and Paste in the code window(VBA Editor)
  5. Save the file as macro enabled workbook
  6. Press ‘F5’ to run it or Keep Pressing ‘F8’ to debug the code line by line.
LIMITED TIME OFFER

Leave A Comment


Related pages


project timeline gantt chart templateresource planning spreadsheet excelexcel pivot table shortcut keyremoving duplicate cells in excelproject management excel dashboard templatesrun macro vbaexcel how to delete duplicate rowswhat is a vlookupmacro to consolidate data from multiple worksheetsinterview worksheetshow to use vlookup step by stepexcel 2007 autosaveexcel macro enabled worksheetproject management spreadsheet templatesexcel macro create buttonvba return value from userformif statement vbaexcel vba change cell colorvba excel copy worksheethow to delete header in excelhow to build macros in excelhow to use iferror function in excel 2010excel timeline project templateexcel vba font colordeveloper mode excel 2010vba current cellexcel vba additemvlookup using two criteriarowsource vbargb excel vbavba create new workbookvba code to read excel filesql dml statements examplesexcel macro copy worksheethow to search for blank cells in exceldefinition of charts in excelhow to insert a drop down box in excel 2007vba cellvba as rangeexcel formula trimrecord a macro in excel 2007excel vba formexcel formulas for namesexcel formula hidepivot excel tutorialexcel vba close formexcel vba workbookrun macro when excel opensdynamic pivot table sql servervb6 color codesexcel all formulas with example 2007unprotect excel spreadsheet 2010how to enable developer tab in excel 2007excel project plan template microsoftexcel protect sheetexcel replace formulavba reference worksheetget file name vbavba userform initializechange rows to columns in excelunhide personal workbookdifference between two dates in excelvba basics pdfvba in excel 2010 tutorial pdfmacro in excel examplevba code to clear cellsexcel count if functionexcel vba codingproject portfolio management excel templateexcel macro commandsvba to close workbookvba active rangeselect vba excelhow to learn vba for excelinsert a checkbox in excel 2010meeting recap format