--- description: If you want to quickly convert an Excel worksheet to a PDF file and then attach this PDF file to an Outlook email to send it, you can utilize the method introduced in this article. It is using VBA to accomplish this task within seconds. title: How to Attach an Excel Worksheet as a PDF Attachment in Your Outlook Email image: https://www.datanumen.com/blogs/wp-content/uploads/2017/07/attach-an-excel-worksheet-as-a-pdf-attachment-in-your-outlook-email.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 Attach an Excel Worksheet as a PDF Attachment in Your Outlook Email # How to Attach an Excel Worksheet as a PDF Attachment in Your Outlook Email [Outlook Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/outlook-solutions/) September 29, 2025 Share Now: - - - - - - - - *If you want to quickly convert an Excel worksheet to a PDF file and then attach this PDF file to an Outlook email to send it, you can utilize the method introduced in this article. It is using VBA to accomplish this task within seconds.* To be honest, to attach an entire Excel workbook as a PDF attachment in an email is pretty easy. You can first save the workbook as a PDF file and then create a new Outlook email and attach the PDF file to this mail. However, in Excel, there is no such a direct function to convert a single worksheet to a PDF file and mail it. Thus, if you want to quickly attach an Excel worksheet as a PDF attachment in an email, you can utilize the following means. ![Attach an Excel Worksheet as a PDF Attachment in Your Outlook Email](https://www.datanumen.com/blogs/wp-content/uploads/2017/07/attach-an-excel-worksheet-as-a-pdf-attachment-in-your-outlook-email.jpg "Attach an Excel Worksheet as a PDF Attachment in Your Outlook Email") ## Attach an Excel Worksheet as a PDF Attachment in Your Email 1. In the first place, you need to open the source Excel worksheet as normal. 2. Then in the Excel window, you should press “Alt + F11” key buttons. 3. Subsequently, you will get access to the Excel VBA editor window in success. 4. After that, you ought to open the “ThisWorkbook” project. 5. Next copy and paste the following VBA code into this project window. ``` Sub SendWorksheet_AsPDFAttachment_OutlookEmail() Dim objFileSystem As Object Dim strTempFile As String Dim objOutlookApp As Outlook.Application Dim objMail As Outlook.MailItem 'Specify the worksheet name Sheets("DataNumen Staff").Activate ActiveSheet.UsedRange.Select ThisWorkbook.Sheets(Array("DataNumen Staff")).Select Set objFileSystem = CreateObject("Scripting.FileSystemObject") strTempFile = objFileSystem.GetSpecialFolder(2).Path & "\" & ActiveSheet.Name & " in " & ThisWorkbook.Name & ".pdf" 'export the specific worksheet as PDF Selection.ExportAsFixedFormat Type:=xlTypePDF, Filename:=strTempFile, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True 'Create a new email Set objOutlookApp = CreateObject("Outlook.Application") Set objMail = objOutlookApp.CreateItem(olMailItem) 'Attach the PDF file objMail.Attachments.Add strTempFile objMail.Display '==>display this email 'Delete the temp PDF file objFileSystem.DeleteFile (strTempFile) End Sub ``` ![VBA Code - Attach an Excel Worksheet as a PDF Attachment in Your Outlook Email]( "VBA Code - Attach an Excel Worksheet as a PDF Attachment in Your Outlook Email") 6. Eventually, to trigger the new macro, you can hit the “Run” icon in the toolbar or straightly press the “F5” key button. 7. After the macro finishes running, a new Outlook email will display at once. In it, you can see a PDF file in the “Attached” line, like the following screenshot:![Attached PDF File]( "Attached PDF File") ## Protect Outlook File from Getting Damaged As we all know, Outlook is prone to corruption, similar to Word documents and Excel workbooks. Therefore, we should understand how to protect Outlook from corruption. Due to the fact that viruses have become more and more complex and rampant, Outlook is frequently corrupt due to virus infection and malware attack. In this situation, you have to install reliable antivirus software and disable auto downloading external files. Furthermore, you’d better get hold of anther robust [Outlook fix](https://www.datanumen.com/outlook-repair/) tool, like DataNumen Outlook Repair. It’s able to provide you with the most effective remedy in the event of Outlook corruption. ## Author Introduction: Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including [fix 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-highlight-occurrences-specific-words-incoming-email-outlook/) [Next post →](https://www.datanumen.com/blogs/find-replace-multiple-items-word-document/) 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\/attach-excel-worksheet-pdf-attachment-outlook-email\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/attach-excel-worksheet-pdf-attachment-outlook-email\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"How to Attach an Excel Worksheet as a PDF Attachment in Your Outlook Email","datePublished":"2017-07-04T09:19:55+00:00","dateModified":"2025-09-29T10:40:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/attach-excel-worksheet-pdf-attachment-outlook-email\/"},"wordCount":412,"commentCount":1,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/attach-excel-worksheet-pdf-attachment-outlook-email\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/07\/attach-an-excel-worksheet-as-a-pdf-attachment-in-your-outlook-email.jpg","articleSection":["Outlook Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/attach-excel-worksheet-pdf-attachment-outlook-email\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/attach-excel-worksheet-pdf-attachment-outlook-email\/","url":"https:\/\/www.datanumen.com\/blogs\/attach-excel-worksheet-pdf-attachment-outlook-email\/","name":"How to Attach an Excel Worksheet as a PDF Attachment in Your Outlook Email","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/attach-excel-worksheet-pdf-attachment-outlook-email\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/attach-excel-worksheet-pdf-attachment-outlook-email\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/07\/attach-an-excel-worksheet-as-a-pdf-attachment-in-your-outlook-email.jpg","datePublished":"2017-07-04T09:19:55+00:00","dateModified":"2025-09-29T10:40:44+00:00","description":"If you want to quickly convert an Excel worksheet to a PDF file and then attach this PDF file to an Outlook email to send it, you can utilize the method introduced in this article. It is using VBA to accomplish this task within seconds.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/attach-excel-worksheet-pdf-attachment-outlook-email\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/attach-excel-worksheet-pdf-attachment-outlook-email\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/07\/attach-an-excel-worksheet-as-a-pdf-attachment-in-your-outlook-email.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/07\/attach-an-excel-worksheet-as-a-pdf-attachment-in-your-outlook-email.jpg","width":1036,"height":445,"caption":"Attach an Excel Worksheet as a PDF Attachment in Your Outlook Email"},{"@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\/"]}]} ```