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.



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])

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()
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.

Leave A Comment

Related pages

formula to delete blank rows in excelproject costing template excelexcel vba interfacecount columns in excel3d chart excelunprotect excel macroexcel vba tutormonthly gantt chart excel templatedatabase dml ddlifcount excelcountifs in excel 2007how to create a new worksheet in excelhow to create adodb connection in vb6how to use a lookup function in excelshortcut key to open excelunderstanding vlookupamazing excel formulascode for comboboxvba isemptyif statement in excel macrohow to add entire column in excelhow to create a spider web chart in excelvba isnumericexcel vba matrixexcel vba onclickexcel vba addressfilesystemobject propertiestrim vba excellearn excel vba step by stepcheckbox in vbahow to run sql query in excelexcel dashboards and reports 2010vba form loadexcel merge multiple worksheets into oneexcel vba userform tutorial pdfhow to insert a title on excelstacked and clustered chart excellearn to code vbainserting in excelexcel macro close without savingvba numberformatsorting sqlhow to merge to cells in excelexcel macro rename fileexcel 2010 lookup function3d charts excelvba index colorvalue vbavba create graphisna with vlookupexcel macro delete columnvba merge cellsexcel vba basicshow to select different rows in excelsumif vbavba execute sqlsimple explanation of vlookupvba select multiple sheetsmacro codes for excellooping in excelexcel developer menuvba code to open excel workbookfor loop vba examplepivot table tutorial excel 2010bubble chart in excelexcel vba macrovlookup excel 2003 examplehow to unhide everything in excelhow to highlight duplicate rows in exceladvanced excel shortcuts pdfisblank function in exceluses of macro in excelproject status report template powerpointhow to avoid duplicates in excelinsert rows vbavba for stepinsert row macro excelhow do i insert rows in excelexcel filter based on cell valuevba step by step runexcel 2003 lookuphow to unlock locked excel file