--- description: If you would like to send all worksheets in an Excel workbook as separate Outlook emails, you can use the method introduced in this article. It can guide you to realize it in bulk without troublesomely sending one by one. title: How to Batch Send All Worksheets in One Excel Workbook as Separate Outlook Emails image: https://www.datanumen.com/blogs/wp-content/uploads/2017/09/batch-send-all-worksheets-in-one-excel-workbook-as-separate-outlook-emails.jpg --- - - - [Home](https://www.datanumen.com/blogs/) > [Solutions](https://www.datanumen.com/blogs/category/solutions/) > [Office Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/) > [Outlook Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/outlook-solutions/) > How to Batch Send All Worksheets in One Excel Workbook as Separate Outlook Emails # How to Batch Send All Worksheets in One Excel Workbook as Separate Outlook Emails [Outlook Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/outlook-solutions/) September 29, 2025 Share Now: - - - - - - - - *If you would like to send all worksheets in an Excel workbook as separate Outlook emails, you can use the method introduced in this article. It can guide you to realize it in bulk without troublesomely sending one by one.* In my previous post “ [2 Quick Methods to Send an Excel Worksheet as an Outlook Email](https://www.datanumen.com/outlook-repair/)”, you can learn two ways to send one Excel worksheet as email. If you wish to batch send all worksheets in one workbook as individual emails, using either of the two means mentioned in that post will be quite tedious and troublesome. Thus, here we’ll introduce another way, which can realize such “Batch Send” in a quick time. ![Batch Send All Worksheets in One Excel Workbook as Separate Outlook Emails](https://www.datanumen.com/blogs/wp-content/uploads/2017/09/batch-send-all-worksheets-in-one-excel-workbook-as-separate-outlook-emails.jpg "Batch Send All Worksheets in One Excel Workbook as Separate Outlook Emails") ## Batch Send All Worksheets in One Excel Workbook as Separate Emails 1. In the first place, you should open the source Excel workbook. 2. Then, after entering the Excel window, you ought to tap on the “Alt + F11” key shortcuts. 3. Next, another window called as “Microsoft Visual Basic for Applications” will display. 4. In it, you have to open an unused module or insert a new module. 5. Subsequently, you can copy the following VBA code into this module. ``` Sub SendEachWorksheet_inOutlookEmail() Dim objWorksheet As Excel.Worksheet Dim objRange As Excel.Range Dim objTempWorkbook As Excel.Workbook Dim objTempWorksheet As Excel.Worksheet Dim strTempFolder As String Dim strHTMLFile As String Dim objHTMLFile As Object Dim objFileSystem As Object Dim objTextStream As Object Dim objOutlookApp As Outlook.Application Dim objMail As Outlook.MailItem For Each objWorksheet In ActiveWorkbook.Sheets Set objRange = objWorksheet.UsedRange objRange.Copy Set objTempWorkbook = Excel.Application.Workbooks.Add(1) Set objTempWorksheet = objTempWorkbook.Sheets(1) With objTempWorksheet.Cells(1) .PasteSpecial xlPasteValues .PasteSpecial xlPasteColumnWidths .PasteSpecial xlPasteFormats End With strTempFolder = CStr(Environ("USERPROFILE")) & "\AppData\Local\Temp" strHTMLFile = strTempFolder & "\Temp" & Format(Now, "yyyymmddhhmmss") & ".htm" Set objHTMLFile = objTempWorkbook.PublishObjects.Add(xlSourceRange, strHTMLFile, objTempWorksheet.Name, objTempWorksheet.UsedRange.Address) objHTMLFile.Publish (True) Set objOutlookApp = CreateObject("Outlook.Application") Set objMail = objOutlookApp.CreateItem(olMailItem) Set objFileSystem = CreateObject("Scripting.FileSystemObject") Set objTextStream = objFileSystem.OpenTextFile(strHTMLFile) objMail.HTMLBody = objTextStream.ReadAll 'Change the email details as per your needs With objMail .To = "test@datanumen.com" .Subject = objWorksheet.Name .Display End With objTextStream.Close objTempWorkbook.Close False Kill strHTMLFile Next End Sub ``` ![VBA Code - Batch Send All Worksheets in One Excel Workbook as Separate Outlook Emails]( "VBA Code - Batch Send All Worksheets in One Excel Workbook as Separate Outlook Emails") 6. After that, you could trigger this macro by pressing F5 key button or clicking the “Run” icon in the toolbar. 7. At once, the emails, which are corresponding to all worksheets in this Excel workbook, will display in Outlook. 8. Finally, you can re-check all the emails’ details and lastly click “Send” button to send the emails out. ## Apply a Potent Recovery Tool if No Backups More and more users have understood the importance of data backups. As long as you’ve backed up your PST file, [PST recovery](https://www.datanumen.com/outlook-repair/) after damage will be quite simple. But if there is not an effective and up-to-date PST backup, you have no choice but to take aid of an external PST repair tool, like DataNumen Outlook Repair. It can repair compromised PST files like a breeze. ## Author Introduction: Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including [recover sql](https://www.datanumen.com/sql-recovery/) and outlook repair software products. For more information visit [www.datanumen.com](https://www.datanumen.com/) Share Now: - - - - - - - - [← Previous post](https://www.datanumen.com/blogs/auto-use-specific-printer-print-outlook-emails/) [Next post →](https://www.datanumen.com/blogs/auto-set-emails-sensitivity-based-recipients-outlook/) Comments are closed. ![Data Recovery Blog]() Follow or like us on Facebook, LinkedIn and Twitter to get all promotions, latest news and updates on our products and company. - - - ### Featured Products - [DataNumen Outlook Repair](https://www.datanumen.com/outlook-repair/) - [DataNumen SQL Recovery](https://www.datanumen.com/sql-recovery/) - [DataNumen Exchange Recovery](https://www.datanumen.com/exchange-recovery/) - [DataNumen Access Repair](https://www.datanumen.com/access-repair/) - [DataNumen Excel Repair](https://www.datanumen.com/excel-repair/) - [DataNumen PDF Repair](https://www.datanumen.com/pdf-repair/) - [DataNumen Word Repair](https://www.datanumen.com/word-repair/) - [DataNumen Zip Repair](https://www.datanumen.com/zip-repair/) ### Popular posts ```json {"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.datanumen.com\/blogs\/batch-send-worksheets-one-excel-workbook-separate-outlook-emails\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/batch-send-worksheets-one-excel-workbook-separate-outlook-emails\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"How to Batch Send All Worksheets in One Excel Workbook as Separate Outlook Emails","datePublished":"2017-09-08T02:39:00+00:00","dateModified":"2025-09-29T10:38:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/batch-send-worksheets-one-excel-workbook-separate-outlook-emails\/"},"wordCount":370,"commentCount":1,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/batch-send-worksheets-one-excel-workbook-separate-outlook-emails\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/09\/batch-send-all-worksheets-in-one-excel-workbook-as-separate-outlook-emails.jpg","articleSection":["Outlook Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/batch-send-worksheets-one-excel-workbook-separate-outlook-emails\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/batch-send-worksheets-one-excel-workbook-separate-outlook-emails\/","url":"https:\/\/www.datanumen.com\/blogs\/batch-send-worksheets-one-excel-workbook-separate-outlook-emails\/","name":"How to Batch Send All Worksheets in One Excel Workbook as Separate Outlook Emails","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/batch-send-worksheets-one-excel-workbook-separate-outlook-emails\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/batch-send-worksheets-one-excel-workbook-separate-outlook-emails\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/09\/batch-send-all-worksheets-in-one-excel-workbook-as-separate-outlook-emails.jpg","datePublished":"2017-09-08T02:39:00+00:00","dateModified":"2025-09-29T10:38:47+00:00","description":"If you would like to send all worksheets in an Excel workbook as separate Outlook emails, you can use the method introduced in this article. It can guide you to realize it in bulk without troublesomely sending one by one.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/batch-send-worksheets-one-excel-workbook-separate-outlook-emails\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/batch-send-worksheets-one-excel-workbook-separate-outlook-emails\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/09\/batch-send-all-worksheets-in-one-excel-workbook-as-separate-outlook-emails.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/09\/batch-send-all-worksheets-in-one-excel-workbook-as-separate-outlook-emails.jpg","width":1300,"height":913,"caption":"Batch Send All Worksheets in One Excel Workbook as Separate Outlook Emails"},{"@type":"WebSite","@id":"https:\/\/www.datanumen.com\/blogs\/#website","url":"https:\/\/www.datanumen.com\/blogs\/","name":"Data Recovery Blog","description":"Discuss every aspect of data recovery","publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datanumen.com\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.datanumen.com\/blogs\/#organization","name":"Data Recovery Blog","url":"https:\/\/www.datanumen.com\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","width":296,"height":397,"caption":"Data Recovery Blog"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataNumen","https:\/\/x.com\/DataNumen","http:\/\/www.linkedin.com\/company\/datanumen","https:\/\/myspace.com\/datanumen\/","http:\/\/www.pinterest.com\/datanumen\/","https:\/\/www.youtube.com\/channel\/UCVIIuuKfUBHSJauUaVP13tw"]},{"@type":"Person","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957","name":"AuthorCCW","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","caption":"AuthorCCW"},"sameAs":["https:\/\/www.datanumen.com\/"]}]} ```