{"id":4882,"date":"2025-02-10T11:23:20","date_gmt":"2025-02-10T11:23:20","guid":{"rendered":"http:\/\/www.repairmsexcel.com\/blog\/?p=4882"},"modified":"2025-02-13T15:54:10","modified_gmt":"2025-02-13T15:54:10","slug":"send-specific-worksheet-as-email-attachment","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment","title":{"rendered":"How to Send Only One Sheet in Excel Via Email?"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">Sometimes, Excel users need to send a specific worksheet or cell as an email attachment to the head of the company or college. For this purpose, you must have the knowledge of sending the worksheet or cell as an Email. In this blog, you will get to know step-by-step methods on <strong>how to send only one sheet in Excel via Email<\/strong>. This helps keep your data organized, protects sensitive information, and ensures that the recipient gets only the relevant data.<\/p>\n<p><!--more--><\/p>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To recover lost Excel data, we recommend this tool:<\/strong><\/p><p style='font-size: 17px;'>This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:<\/p><div><ol style='font-size: 17px; margin-top: 4px;'><li><strong><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'>Try Excel File Repair Tool<\/a><\/strong> rated <i>Excellent<\/i> by Softpedia, Softonic & CNET.<\/li><li>Select the corrupt Excel file (XLS, XLSX) & click <b>Repair<\/b> to initiate the repair process.<\/li><li>Preview the repaired files and click <b>Save File<\/b> to save the files at desired location.<\/li><\/ol><\/div><\/div><\/div><br>\n<h2 style=\"text-align: left;\"><strong>Can Excel Send Email Based on Cell Value?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Yes, Microsoft Excel can send you automatic emails each time the cell value changes, when the spreadsheet is updated, or when a condition is met. Thus, send an Email totally based on the cell value.<\/p>\n<h2 style=\"text-align: left;\"><strong>What Are The Steps To Add Send to Mail Recipient Icon?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Go through the steps below to add Send To Mail Recipient icon in your Excel:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Click on the <strong>File<\/strong> menu in Excel.<\/li>\n<li>Select <strong>Options<\/strong> from the menu.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-7700 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/12\/choose-and-click-options-1.png\" alt=\"Make Sure the AutoSave Feature Is Enabled\" width=\"495\" height=\"627\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Select the <strong>Quick Access Toolbar <\/strong>option<strong>.<\/strong><\/li>\n<li>Under <strong>Choose commands from<\/strong>\u00a0select <strong>All Commands<\/strong>.<\/li>\n<li style=\"text-align: justify;\">Then scroll down and choose to <strong>Send to Mail Recipient<\/strong>.<\/li>\n<li style=\"text-align: justify;\">To add the Send to Mail Recipient in the right pane of <strong>Customize Quick Access Toolbar:<\/strong> click on <strong>Add<\/strong>.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4886 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Add.png\" alt=\"Send Single Or Multiple Excel Worksheets As An Email Attachment\" width=\"304\" height=\"231\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Add.png 357w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Add-300x228.png 300w\" sizes=\"auto, (max-width: 304px) 100vw, 304px\" \/><\/p>\n<ul>\n<li>Click on the <strong>Ok <\/strong>button<strong>.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4889 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Ok.png\" alt=\"Send Single Or Multiple Excel Worksheets As An Email Attachment1\" width=\"438\" height=\"399\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Ok.png 541w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Ok-300x273.png 300w\" sizes=\"auto, (max-width: 438px) 100vw, 438px\" \/><\/p>\n<p style=\"text-align: justify;\">You will find the Send to Mail Recipient icon on the top left side of Excel. Now go for the different ways on how to send only one sheet in Excel via Email.<\/p>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/share-excel-workbook\">How To Share Excel Workbook With Multiple User?<\/a><\/strong><\/p>\n<\/blockquote>\n<h2>How to Send Only One Sheet In Excel Via Email?<\/h2>\n<h3><strong><u>1# Send Specific Worksheet As Email Attachment<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">It\u2019s not possible to attach a single worksheet in Email, as it can only attach files to send through Emails.<\/p>\n<p style=\"text-align: justify;\">If you want to send the specific worksheet through Email then you have to first create a workbook file. So, follow the below-given steps to <strong>send\u00a0 specific worksheet or cell as<\/strong><strong> Email attachment.<\/strong><\/p>\n<p style=\"text-align: justify;\">First, right-click on the particular worksheet that you want to attach to the Email.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Click on the <strong>Move or Copy\u2026 <\/strong>option<strong>.<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4895 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/Copy-sheet-Example-4.png\" alt=\" send an Excel worksheet as an email attachment\" width=\"304\" height=\"258\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/Copy-sheet-Example-4.png 361w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/Copy-sheet-Example-4-300x254.png 300w\" sizes=\"auto, (max-width: 304px) 100vw, 304px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">In the Move or Copy dialogue box, select <strong>(new book)<\/strong> under <strong>To book:<\/strong> list.<\/li>\n<li style=\"text-align: justify;\">Select <strong>Create a copy <\/strong>checkbox<strong>.<\/strong><\/li>\n<li style=\"text-align: justify;\">Then click <strong>Ok<\/strong>. You will see your new workbook file with a copy of your selected single worksheet.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4896 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/Move-or-Copy-to-Create-a-Duplicate-Sheet.png\" alt=\" send single or multiple Excel worksheets as an Email attachment\" width=\"273\" height=\"261\" \/><\/p>\n<ul>\n<li>Now click on <strong>Send to Mail Recipient <\/strong>icon.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4887 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Added-to-QAT-1.png\" alt=\"Send Specific Worksheet As Email Attachment\" width=\"542\" height=\"80\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Added-to-QAT-1.png 542w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Added-to-QAT-1-300x44.png 300w\" sizes=\"auto, (max-width: 542px) 100vw, 542px\" \/><\/p>\n<ul>\n<li>Select <strong>send the entire workbook as an attachment<\/strong>.<\/li>\n<li>Click on <strong>Ok<\/strong>. It will attach your newly created workbook file.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4890 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Send-emtiure-workbook.png\" alt=\"Send Entire Workbook As Email Attachment3\" width=\"378\" height=\"153\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Send-emtiure-workbook.png 378w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Send-emtiure-workbook-300x121.png 300w\" sizes=\"auto, (max-width: 378px) 100vw, 378px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">Click on the <strong>Send <\/strong>button<strong>.<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Using these above steps you can create a new workbook file and <strong>send single excel worksheet as email attachment.<\/strong><\/p>\n<p style=\"text-align: justify;\">After emailing, you can delete that newly created file as already you have that specific worksheet in your original workbook.<\/p>\n<h3><strong><u>2# Send Entire Workbook As Email Attachment<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">If you want to <strong>send the entire workbook with multiple sheets as an Email attachment<\/strong>, go for the below steps:<\/p>\n<ul>\n<li style=\"text-align: justify;\">First, click on <strong>Send to Mail recipient <\/strong>icon in Excel.<\/li>\n<li style=\"text-align: justify;\">Select <strong>send the entire workbook as an attachment <\/strong>in the email dialogue box.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4890 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Send-emtiure-workbook.png\" alt=\"Send Entire Workbook As Email Attachment2\" width=\"378\" height=\"153\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Send-emtiure-workbook.png 378w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Send-emtiure-workbook-300x121.png 300w\" sizes=\"auto, (max-width: 378px) 100vw, 378px\" \/><\/p>\n<ul>\n<li>Click <strong>Ok<\/strong>. It will attach your entire workbook file in an Email dialogue box.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4888 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Email-Attachment.png\" alt=\"Send Entire Workbook As Email Attachment\" width=\"457\" height=\"257\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Email-Attachment.png 569w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Email-Attachment-300x169.png 300w\" sizes=\"auto, (max-width: 457px) 100vw, 457px\" \/><\/p>\n<ul>\n<li>Click on the <strong>Send <\/strong>button<strong>.<\/strong><\/li>\n<\/ul>\n<p>The above steps will attach your entire workbook in Email.<\/p>\n<h3 style=\"text-align: left;\"><span style=\"text-decoration: underline;\"><strong>3# Save as PDF and Email<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">Most of the time, the recipient doesn\u2019t need an editable file, in such a case, sending a file in PDF is a great option. To do so, follow the below steps:<\/p>\n<ul>\n<li style=\"text-align: left;\">Open your Excel sheet.<\/li>\n<li style=\"text-align: left;\">Navigate to <strong>File<\/strong> &gt; <strong>Save As<\/strong>.<\/li>\n<li style=\"text-align: left;\">Select <strong>PDF<\/strong> as the file format.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7740 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/08\/Save-As-Dialog.png\" alt=\"Save Entire Excel Workbook As A PDF\" width=\"674\" height=\"507\" \/><\/p>\n<ul>\n<li style=\"text-align: left;\">Save a file to your chosen location.<\/li>\n<li style=\"text-align: left;\">Attach a PDF to an email &amp; send it.<\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><strong><u>4# Send Excel Worksheet Using VBA Code<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">If you send Excel worksheets on a regular basis, then you can use below mentioned VBA code. Follow the below steps to <strong>send specific worksheet or cell as Email attachment <\/strong> using VBA code:<\/p>\n<ul style=\"text-align: justify;\">\n<li>First, open the workbook from which you want to select the range of cells.<\/li>\n<li>To open <strong>Microsoft Visual Basic<\/strong>, press and hold <strong>ALT + F11 keys<\/strong>.<\/li>\n<li>Click on <strong>Insert<\/strong>.<\/li>\n<li>Select <strong>Module<\/strong>.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4898 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/run-code-from-a-module-2.png\" alt=\" mail worksheets or cells in Excel1\" width=\"507\" height=\"266\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/run-code-from-a-module-2.png 600w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/run-code-from-a-module-2-300x158.png 300w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/><\/p>\n<ul>\n<li>You will find space for code in the Module window. Copy the below-given code and paste it into the <strong>Module window<\/strong>.<\/li>\n<\/ul>\n<blockquote><p>Option Explicit<\/p>\n<p>Sub EmailandSaveCellValue()<\/p>\n<p>&#8216;Variable declaration<\/p>\n<p>Dim oApp As Object, _<\/p>\n<p>oMail As Object, _<\/p>\n<p>WB As Workbook, _<\/p>\n<p>FileName As String, MailSub As String, MailTxt As String<\/p>\n<p>&#8216;*************************************************\u00a0 ********<\/p>\n<p>&#8216;Set email details; Comment out if not required<\/p>\n<p>Const MailTo = &#8220;some1@someone.com&#8221;<\/p>\n<p>Const MailCC = &#8220;some2@someone.com&#8221;<\/p>\n<p>Const MailBCC = &#8220;some3@someone.com&#8221;<\/p>\n<p>MailSub = &#8220;Please review &#8221; &amp; Range(&#8220;Subject&#8221;)<\/p>\n<p>MailTxt = &#8220;I have attached &#8221; &amp; Range(&#8220;Subject&#8221;)<\/p>\n<p>&#8216;*************************************************\u00a0 ********<\/p>\n<p>&#8216;Turns off screen updating<\/p>\n<p>Application.ScreenUpdating = False<\/p>\n<p>&#8216;Makes a copy of the active sheet and save it to<\/p>\n<p>&#8216;a temporary file<\/p>\n<p>ActiveSheet.Copy<\/p>\n<p>Set WB = ActiveWorkbook<\/p>\n<p>FileName = Range(&#8220;Subject&#8221;) &amp; &#8221; Text.xls&#8221;<\/p>\n<p>On Error Resume Next<\/p>\n<p>Kill &#8220;C:\\&#8221; &amp; FileName<\/p>\n<p>On Error Goto 0<\/p>\n<p>WB.SaveAs FileName:=&#8221;C:\\&#8221; &amp; FileName<\/p>\n<p>&#8216;Creates and shows the outlook mail item<\/p>\n<p>Set oApp = CreateObject(&#8220;Outlook.Application&#8221;)<\/p>\n<p>Set oMail = oApp.CreateItem(0)<\/p>\n<p>With oMail<\/p>\n<p>.To = MailTo<\/p>\n<p><span style=\"vertical-align: inherit;\"><span style=\"vertical-align: inherit;\">.Cc = MailCC<\/span><\/span><\/p>\n<p><span style=\"vertical-align: inherit;\"><span style=\"vertical-align: inherit;\">.Bcc = MailBCC<\/span><\/span><\/p>\n<p>.Subject = MailSub<\/p>\n<p>.Body = MailTxt<\/p>\n<p>.Attachments.Add WB.FullName<\/p>\n<p>.Display<\/p>\n<p>End With<\/p>\n<p>&#8216;Deletes the temporary file<\/p>\n<p>WB.ChangeFileAccess Mode:=xlReadOnly<\/p>\n<p>Kill WB.FullName<\/p>\n<p>WB.Close SaveChanges:=False<\/p>\n<p>&#8216;Restores screen updating and release Outlook<\/p>\n<p>Application.ScreenUpdating = True<\/p>\n<p>Set oMail = Nothing<\/p>\n<p>Set oApp = Nothing<\/p>\n<p>End Sub<\/p><\/blockquote>\n<p><strong><span style=\"color: #ff0000;\">NOTE<\/span>:<\/strong> You can modify this code by changing some of the lines as per your information.<\/p>\n<ul>\n<li>Press <strong>Alt + Q key<\/strong> to close VBE.<\/li>\n<li>Then click on <strong>EmailandSaveCellValue\/Tools\/Macros<\/strong> to execute the code.<\/li>\n<\/ul>\n<h2 style=\"text-align: left;\"><strong>How to Email Selected Cells in Excel?<\/strong><\/h2>\n<p>In this case, you can send the range of cells from the Excel worksheet using several ways that are mentioned below.<\/p>\n<p>By using these methods, you can easily select the cells and send them as an Email attachment.<\/p>\n<h3><strong><u>1# Send Range Of Cell As Email Message Body<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">In this case, you can <strong>send a range of cells through Email<\/strong>. If you want to send only the part of your worksheet then go for the below steps:<\/p>\n<ul>\n<li style=\"text-align: left;\">Click on <strong>Send to Mail recipient <\/strong>icon<strong>.<\/strong><\/li>\n<li style=\"text-align: left;\">In the Email dialogue box, select <strong>Send the current sheet<\/strong> <strong>as the message body <\/strong>option<strong>.<\/strong><\/li>\n<li style=\"text-align: left;\">Click on the <strong>Ok <\/strong>button<strong>.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4897 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/send-the-current-sheet-as-the-message-body.jpg\" alt=\"send the entire workbook with a multiple sheets as an Email attachment\" width=\"467\" height=\"190\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/send-the-current-sheet-as-the-message-body.jpg 499w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/send-the-current-sheet-as-the-message-body-300x122.jpg 300w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/p>\n<ul>\n<li style=\"text-align: left;\">You will find the current worksheet in the Email body. Then <strong>select the range of cells<\/strong> from the Email message body.<\/li>\n<li style=\"text-align: left;\">In the Email dialogue box, enter <strong>recipient<\/strong> and <strong>subject<\/strong>.<\/li>\n<li style=\"text-align: left;\">Click on <strong>Send this Selection<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4891 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Send-Selection.png\" alt=\"Send Range Of Cell Through Email\" width=\"417\" height=\"416\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Send-Selection.png 469w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Send-Selection-300x300.png 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/How-to-Send-Single-Excel-Worksheet-as-Email-Attachment-Send-Selection-150x150.png 150w\" sizes=\"auto, (max-width: 417px) 100vw, 417px\" \/><\/p>\n<ul>\n<li>Click on the <strong>Send <\/strong>button<strong>.<\/strong><\/li>\n<\/ul>\n<h3><strong><u>2# Send Range Of Cell Using VBA Code<\/u><\/strong><\/h3>\n<p>You can also send a range of cells from the worksheet using VBA Code as an Outlook Email attachment. So, go through the below steps:<\/p>\n<ul>\n<li>First, open the Excel workbook from which you want to send the range of cells as Email.<\/li>\n<li>To open Excel VBA Editor, press the <strong>Alt + F11<\/strong> key.<\/li>\n<li>Then in Excel VBA Editor, click on <strong>Insert<\/strong>.<\/li>\n<li>Select <strong>Module<\/strong> option.<\/li>\n<li>Now turn on your <strong>Microsoft Outlook Object.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4910 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/enable-outlook-object-in-excel-500x320-1.jpg\" alt=\"Send Range Of Cell Using VBA Code\" width=\"522\" height=\"334\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/enable-outlook-object-in-excel-500x320-1.jpg 500w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/enable-outlook-object-in-excel-500x320-1-300x192.jpg 300w\" sizes=\"auto, (max-width: 522px) 100vw, 522px\" \/><\/p>\n<ul>\n<li>Click on the <strong>Tools<\/strong> tab.<\/li>\n<li>Select <strong>References\u2026<\/strong> from the context menu.<\/li>\n<li>In the Reference-VBA project dialogue box, search for<strong> Microsoft Outlook Object Library<\/strong> and select its checkbox.<\/li>\n<li>Now copy the below-given code and paste it into Module Window.<\/li>\n<\/ul>\n<blockquote><p>Sub SendSelectedCells_inOutlookEmail()Dim objSelection As Excel.RangeDim objTempWorkbook As Excel.WorkbookDim objTempWorksheet As Excel.WorksheetDim strTempHTMLFile As StringDim objTempHTMLFile As ObjectDim objFileSystem As ObjectDim objTextStream As ObjectDim objOutlookApp As Outlook.ApplicationDim objNewEmail As Outlook.MailItem<\/p>\n<p>&#8216;Copy the selectionSet objSelection = SelectionSelection.Copy<\/p>\n<p>&#8216;Paste the copied selected ranges into a temp worksheetSet objTempWorkbook = Excel.Application.Workbooks.Add(1)Set objTempWorksheet = objTempWorkbook.Sheets(1)<\/p>\n<p>&#8216;Keep the values, column widths and formats in pastingWith objTempWorksheet.Cells(1)<\/p>\n<p>.PasteSpecialxlPasteValues<\/p>\n<p>.PasteSpecialxlPasteColumnWidths<\/p>\n<p>.PasteSpecialxlPasteFormats<\/p>\n<p>End With&#8217;Save the temp worksheet as a HTML fileSet objFileSystem = CreateObject(&#8220;Scripting.FileSystemObject&#8221;)strTempHTMLFile = objFileSystem.GetSpecialFolder(2).Path &amp;&#8221;\\Temp for Excel&#8221; &amp; Format(Now, &#8220;YYYY-MM-DD hh-mm-ss&#8221;) &amp; &#8220;.htm&#8221;Set objTempHTMLFile = objTempWorkbook.PublishObjects.Add(xlSourceRange, strTempHTMLFile, objTempWorksheet.Name, objTempWorksheet.UsedRange.Address)objTempHTMLFile.Publish (True)<\/p>\n<p>&#8216;Create a new emailSet objOutlookApp = CreateObject(&#8220;Outlook.Application&#8221;)Set objNewEmail = objOutlookApp.CreateItem(olMailItem)<\/p>\n<p>&#8216;Read the HTML file data and insert into the email bodySet objTextStream = objFileSystem.OpenTextFile(strTempHTMLFile)objNewEmail.HTMLBody = objTextStream.ReadAllobjNewEmail.Display&#8217;You can specify the new email recipients, subjects here using the following lines:&#8217;objNewEmail.To = jyotismith@excel.com&#8217;objNewEmail.Subject = &#8220;Excel Repair Products&#8221;&#8216;objNewEmail.Send &#8211;&gt; directly send out this emailobjTextStream.CloseobjTempWorkbook.Close (False)objFileSystem.DeleteFile (strTempHTMLFile)End Sub<\/p><\/blockquote>\n<p><strong>NOTE:<\/strong> You can modify this code by changing some of the lines as per your information.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4911 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/vba-code-send-selected-cells-as-outlook-email-500x267-1.jpg\" alt=\"Send Range Of Cell Using VBA Code1\" width=\"536\" height=\"286\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/vba-code-send-selected-cells-as-outlook-email-500x267-1.jpg 500w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/vba-code-send-selected-cells-as-outlook-email-500x267-1-300x160.jpg 300w\" sizes=\"auto, (max-width: 536px) 100vw, 536px\" \/><\/p>\n<ul>\n<li>Save the code and select the cells you want to send.<\/li>\n<li>Go to new <strong>macro<\/strong>.<\/li>\n<li>Click on the <strong>F5 key.<\/strong><\/li>\n<li>You will find an email displaying your selected cells.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4912 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/new-email-containing-selected-cells-500x270-1.jpg\" alt=\"Send Range Of Cell Using VBA Code3\" width=\"500\" height=\"270\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/new-email-containing-selected-cells-500x270-1.jpg 500w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/new-email-containing-selected-cells-500x270-1-300x162.jpg 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/p>\n<h3><strong><u>3# Copy And Paste Cells<\/u><\/strong><\/h3>\n<p>You can manually copy and paste the range of cells from your worksheet as an Outlook Email. Go through the steps below to send cells through Outlook Email:<\/p>\n<ul>\n<li>Open the <strong>Workbook file<\/strong> and select the cells from the specific worksheet.<\/li>\n<li>Copy the cells by pressing <strong>Ctrl + C key.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4913 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/copy-selected-cells-500x228-1.jpg\" alt=\"Copy And Paste Cells\" width=\"500\" height=\"228\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/copy-selected-cells-500x228-1.jpg 500w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/copy-selected-cells-500x228-1-300x137.jpg 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/p>\n<ul>\n<li>Open your <strong>Outlook app<\/strong>.<\/li>\n<li>In Outlook, click on the <strong>Home<\/strong> tab.<\/li>\n<li>Select <strong>New message<\/strong>.<\/li>\n<li>Then click on the <strong>email body section<\/strong>.<\/li>\n<li>Now press <strong>Ctrl + V key<\/strong>. It will paste your copied selected cells.<\/li>\n<li>Enter <strong>recipient<\/strong> and <strong>subject <\/strong>and click on<strong> the Send <\/strong>button<strong>.<\/strong><\/li>\n<\/ul>\n<p>The above steps will send the selected cells of a worksheet to the recipient.<\/p>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <a href=\"https:\/\/www.repairmsexcel.com\/blog\/unable-to-save-excel-file-to-shared-network-drives\">Unable to Save Excel File to Shared Network Drives!<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>How to Attach Excel Files to Email?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Instead of sending specific or multiple worksheets, if you want to send the Excel files through Email then go below steps:<\/p>\n<ol style=\"text-align: justify;\">\n<li>Click on <strong>Attach button<\/strong> in the Email and locate the file you want to send.<\/li>\n<\/ol>\n<ul>\n<li>To locate the file in Windows 10:<\/li>\n<\/ul>\n<p>Go to <strong>Quick Access<\/strong> then scroll down, and you will find your recent files.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4899 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/Quick-Access-folder-for-List-of-Recent-Files-and-Folders-in-Windows-10.png\" alt=\"Attach Excel Files To Email1\" width=\"486\" height=\"310\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/Quick-Access-folder-for-List-of-Recent-Files-and-Folders-in-Windows-10.png 614w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/Quick-Access-folder-for-List-of-Recent-Files-and-Folders-in-Windows-10-300x192.png 300w\" sizes=\"auto, (max-width: 486px) 100vw, 486px\" \/><\/p>\n<ul>\n<li>To locate the file in Mac:<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Go to <strong>All My Files<\/strong> and click on <strong>Date modified<\/strong>, you will find the recent files in the column.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4892 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/Mac-Mail-Sort-by-Date-Modified-to-View-Recent-Files-552x400-1.png\" alt=\"Attach Excel Files To Email1\" width=\"552\" height=\"400\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/Mac-Mail-Sort-by-Date-Modified-to-View-Recent-Files-552x400-1.png 552w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/Mac-Mail-Sort-by-Date-Modified-to-View-Recent-Files-552x400-1-300x217.png 300w\" sizes=\"auto, (max-width: 552px) 100vw, 552px\" \/><\/p>\n<ol start=\"2\">\n<li style=\"text-align: justify;\">Copy and paste the <strong>file path<\/strong>.<\/li>\n<\/ol>\n<ul>\n<li style=\"text-align: justify;\">Click on the <strong>File<\/strong> menu in Excel.<\/li>\n<li style=\"text-align: justify;\">Select the <strong>Info option<\/strong> from the menu.<\/li>\n<\/ul>\n<p><strong>(Excel 2013 and Excel 2016)\u00a0<\/strong><\/p>\n<ul>\n<li>Left-click on the <strong>file path<\/strong> and select <strong>Copy link to clipboard<\/strong>.\u00a0 \u00a0 \u00a0 <strong>(Excel 2010)\u00a0 \u00a0<\/strong><\/li>\n<li>Press <strong>Ctrl + C key<\/strong> to copy the file path.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4885 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/Excel-Copy-Full-File-Path-to-Clipboard.png\" alt=\"Attach Excel Files To Email\" width=\"427\" height=\"287\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/Excel-Copy-Full-File-Path-to-Clipboard.png 427w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/Excel-Copy-Full-File-Path-to-Clipboard-300x202.png 300w\" sizes=\"auto, (max-width: 427px) 100vw, 427px\" \/><\/p>\n<ul>\n<li>Paste the copied file path to <strong>File Name:<\/strong> in an email attachment.<\/li>\n<li>Click on the <strong>Insert <\/strong>button<strong>.<\/strong><\/li>\n<\/ul>\n<p>In this way, you can attach your Excel files and send them through Email.<\/p>\n<h2 style=\"text-align: left;\"><strong>Related FAQs:<\/strong><\/h2>\n        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Can I Email Just One Sheet of An Excel Workbook?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYes, you can email just one sheet of an Excel workbook by following these steps: <ul><li>Right-click on a tab of your worksheet to email. <\/li><li>For sending more than one worksheet, you have to hold down <strong>CTRL<\/strong> key &amp; click. <\/li><li>In this workbook, simply click on <strong>File, Share, Email<\/strong>, select Send as Attachment.                     <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do I Send Only One Sheet in Excel to WhatsApp?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tSince you want to send a single sheet in Excel to WhatsApp, you need to follow the below steps: <ul><li>Install rocketsend.io extension and add to Chrome. <\/li><li>Go to WhatsApp Web <\/li><li>Now, create an Excel worksheet with columns for names, phone numbers, and country codes <\/li><li>Then, save your file as a CSV <\/li><li>In a <strong>rocketsend.io pane<\/strong>, you have to click on Upload CSV <\/li><li>Choose the CSV file you created <\/li><li>After this, map the phone numbers to a field in the file <\/li><li>Finally, click on <strong>Send WhatsApp<\/strong>.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How to Create a Link to A Specific Sheet in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tIf you want to create a link to a specific sheet in Excel, open worksheet, select cell(s) where you need to create a link. On an Insert tab, choose Hyperlink &amp; type the text you want to use to represent the link.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t\n<script type=\"application\/ld+json\">\n    {\n\t\t\"@context\": \"https:\/\/schema.org\",\n\t\t\"@type\": \"FAQPage\",\n\t\t\"mainEntity\": [\n\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Can I Email Just One Sheet of An Excel Workbook?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Yes, you can email just one sheet of an Excel workbook by following these steps: &lt;ul&gt;&lt;li&gt;Right-click on a tab of your worksheet to email. &lt;\/li&gt;&lt;li&gt;For sending more than one worksheet, you have to hold down <strong>CTRL<\/strong> key &amp; click. &lt;\/li&gt;&lt;li&gt;In this workbook, simply click on <strong>File, Share, Email<\/strong>, select Send as Attachment.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Do I Send Only One Sheet in Excel to WhatsApp?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Since you want to send a single sheet in Excel to WhatsApp, you need to follow the below steps: &lt;ul&gt;&lt;li&gt;Install rocketsend.io extension and add to Chrome. &lt;\/li&gt;&lt;li&gt;Go to WhatsApp Web &lt;\/li&gt;&lt;li&gt;Now, create an Excel worksheet with columns for names, phone numbers, and country codes &lt;\/li&gt;&lt;li&gt;Then, save your file as a CSV &lt;\/li&gt;&lt;li&gt;In a <strong>rocketsend.io pane<\/strong>, you have to click on Upload CSV &lt;\/li&gt;&lt;li&gt;Choose the CSV file you created &lt;\/li&gt;&lt;li&gt;After this, map the phone numbers to a field in the file &lt;\/li&gt;&lt;li&gt;Finally, click on <strong>Send WhatsApp<\/strong>.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How to Create a Link to A Specific Sheet in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"If you want to create a link to a specific sheet in Excel, open worksheet, select cell(s) where you need to create a link. On an Insert tab, choose Hyperlink &amp; type the text you want to use to represent the link.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t    ]\n}\n<\/script>\n\n<h2 style=\"text-align: left;\"><strong>Final Thoughts<\/strong><\/h2>\n<p style=\"text-align: justify;\">Sending only one sheet from an Excel file is simple and effective. Whether using manual ways or VBA, these practices help you solve <strong>how to share only specific sheet\/single tab in Excel spreadsheet<\/strong> and streamline your workflow. Choose the method that best suits your needs and keep your data secure and organized.<\/p>\n<p>I hope you enjoyed reading this post!<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><strong>External References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/how-to-attach-only-one-sheet-of-excel-workbook-to\/59771d89-0ddd-47c3-925c-b85d7f38ddae\" target=\"_blank\" rel=\"noopener\">https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/how-to-attach-only-one-sheet-of-excel-workbook-to\/59771d89-0ddd-47c3-925c-b85d7f38ddae<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n<p style=\"text-align: justify;\"><span style=\"vertical-align: inherit;\"><span style=\"vertical-align: inherit;\"><br><center><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' title='Try Excel Repair Now'><img src='https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-en.png' \/><\/a><\/center><br><\/span><\/span><\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Sometimes, Excel users need to send a specific worksheet or cell as an email attachment to the head of the &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Send Only One Sheet in Excel Via Email?\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment#more-4882\" aria-label=\"Read more about How to Send Only One Sheet in Excel Via Email?\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":4915,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[632],"tags":[1910,1911,1912],"class_list":["post-4882","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-how-to-send-only-one-sheet-in-excel-via-email","tag-how-to-send-single-sheet-in-excel","tag-how-to-share-only-specific-sheet-single-tab-in-excel-spreadsheet","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Send Only One Sheet in Excel Via Email?<\/title>\n<meta name=\"description\" content=\"Learn how to send only one sheet in Excel via Email attachment by following some quick ways mentioned here.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Send Only One Sheet in Excel Via Email?\" \/>\n<meta property=\"og:description\" content=\"Learn how to send only one sheet in Excel via Email attachment by following some quick ways mentioned here.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-10T11:23:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-13T15:54:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/send-worksheet-as-email-copy.png\" \/>\n\t<meta property=\"og:image:width\" content=\"930\" \/>\n\t<meta property=\"og:image:height\" content=\"457\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/send-specific-worksheet-as-email-attachment#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/send-specific-worksheet-as-email-attachment\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"How to Send Only One Sheet in Excel Via Email?\",\"datePublished\":\"2025-02-10T11:23:20+00:00\",\"dateModified\":\"2025-02-13T15:54:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/send-specific-worksheet-as-email-attachment\"},\"wordCount\":2094,\"publisher\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/send-specific-worksheet-as-email-attachment#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/send-worksheet-as-email-copy.png\",\"keywords\":[\"how to send only one sheet in Excel via Email\",\"how to send single sheet in Excel\",\"how to share only specific sheet\\\/single tab in Excel spreadsheet\"],\"articleSection\":[\"Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/send-specific-worksheet-as-email-attachment\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/send-specific-worksheet-as-email-attachment\",\"name\":\"How to Send Only One Sheet in Excel Via Email?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/send-specific-worksheet-as-email-attachment#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/send-specific-worksheet-as-email-attachment#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/send-worksheet-as-email-copy.png\",\"datePublished\":\"2025-02-10T11:23:20+00:00\",\"dateModified\":\"2025-02-13T15:54:10+00:00\",\"description\":\"Learn how to send only one sheet in Excel via Email attachment by following some quick ways mentioned here.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/send-specific-worksheet-as-email-attachment#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/send-specific-worksheet-as-email-attachment\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/send-specific-worksheet-as-email-attachment#primaryimage\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/send-worksheet-as-email-copy.png\",\"contentUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/send-worksheet-as-email-copy.png\",\"width\":930,\"height\":457,\"caption\":\"Send Specific Worksheet Or Cell As Email Attachment\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/send-specific-worksheet-as-email-attachment#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Send Only One Sheet in Excel Via Email?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\\\/\\\/www.repairmsexcel.com\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/priyanka-sahu-2794a1242\"],\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/author\\\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Send Only One Sheet in Excel Via Email?","description":"Learn how to send only one sheet in Excel via Email attachment by following some quick ways mentioned here.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment","og_locale":"en_US","og_type":"article","og_title":"How to Send Only One Sheet in Excel Via Email?","og_description":"Learn how to send only one sheet in Excel via Email attachment by following some quick ways mentioned here.","og_url":"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment","og_site_name":"Excel File Repair Blog","article_published_time":"2025-02-10T11:23:20+00:00","article_modified_time":"2025-02-13T15:54:10+00:00","og_image":[{"width":930,"height":457,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/send-worksheet-as-email-copy.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"How to Send Only One Sheet in Excel Via Email?","datePublished":"2025-02-10T11:23:20+00:00","dateModified":"2025-02-13T15:54:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment"},"wordCount":2094,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/send-worksheet-as-email-copy.png","keywords":["how to send only one sheet in Excel via Email","how to send single sheet in Excel","how to share only specific sheet\/single tab in Excel spreadsheet"],"articleSection":["Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment","url":"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment","name":"How to Send Only One Sheet in Excel Via Email?","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/send-worksheet-as-email-copy.png","datePublished":"2025-02-10T11:23:20+00:00","dateModified":"2025-02-13T15:54:10+00:00","description":"Learn how to send only one sheet in Excel via Email attachment by following some quick ways mentioned here.","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/send-worksheet-as-email-copy.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/send-worksheet-as-email-copy.png","width":930,"height":457,"caption":"Send Specific Worksheet Or Cell As Email Attachment"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/send-specific-worksheet-as-email-attachment#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"How to Send Only One Sheet in Excel Via Email?"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/4882","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=4882"}],"version-history":[{"count":2,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/4882\/revisions"}],"predecessor-version":[{"id":8913,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/4882\/revisions\/8913"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/4915"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=4882"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=4882"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=4882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}