If you do a lot of work with Excel files, it’s likely that you also send a lot of Excel files via email. There are probably a million different ways to attach a file, and some of them can be awfully slow.
You can spend a lot of time browsing through folders to find the file(s) you want to attach. Then repeat this process when you realize you need to make changes to a file or aren’t sure if you’ve saved it.
Sometimes you may need to send part of a spreadsheet or a single Excel sheet from a workbook to your colleague or supervisor. Although there are other ways to do this, in this tutorial I will show you the quickest and easiest way to email a single Excel spreadsheet or part of an Excel spreadsheet.
Sometimes you may need to integrate an Outlook e-mail message into your workbook. You might think about copying and pasting the contents of the email into the workbook. However, once you copy and paste the Outlook email message into Excel, the message is overloaded and not formatted at all. In fact, you can integrate the email as a subject into the workbook as follows.
Why can’t I attach an Excel document to an email?
- One of the most common reasons why you can’t attach an email attachment is because your computer doesn’t have the software required to recognize the file format. For example, if someone sends you a file and you don’t have another program that supports that format, the file format won’t open.
- If the file format is something that your computer should open but won’t open properly, that file format may be related to the wrong program.
- Or the program it is linked to has errors or has been deleted.
- If you need to send multiple files via email, it is not uncommon to put all files into one compressed file and attach it to the email. If the file is a zip or any other compressed file format, it must be decompressed before it can be attached.
- If you have an anti-virus program installed on your computer, make sure that it does not cause problems with attachments by temporarily disabling it.
- It is also possible that the attachment you received may be corrupted. Reply to the email and ask the sender to check that the attachment works on their computer and create a new email and a new attachment.
How to attach an Excel document to an email
Send in a different format
If Outlook refuses to attach an Excel file, you can also skillfully mask the file in a different format. The best way to do this is to compress the file. To do this, locate the Excel file on your computer, right-click on it, and select Add to Archive. The newly obtained zip file will most likely be accepted as an attachment from Outlook.
In addition, this software includes a file conversion option that allows you to convert your Excel file to another type to see if it is accepted by Outlook. This is the most popular tool for archiving files, but not only that, as it has evolved a lot in recent years. This great tool now has many other tools such as data encryption, data backup, file management, and even file merging.
Recover Excel File
Your Excel file may be rejected by Outlook because it is probably corrupted. Don’t worry, because you can easily recover it with special software.
The purpose of this tool is to protect Excel workbooks and data from corruption. However, it can also recover corrupt Excel files and restore all records and views.
It can recover the entire structure of an Excel file, including tables, graphs, formulas, and even cell comments. It also works with multiple files at once and even supports older versions of Excel from 2000 and 2003 through 2019.
Disable antivirus and a third-party firewall
Some users have confirmed that they have fixed the “Common Email Error” by removing third-party firewall blockers for MS Excel. So try disabling (or uninstalling) third-party antivirus and firewall software to see if it blocks the attachment feature in Excel.
Many antivirus programs include a deactivation option that can be selected by right-clicking on the icon in the taskbar.
Make sure that Outlook is the default email client
- Press the Windows key + the S shortcut.
- Enter the default applications in the search box.
- Click Default Applications to open the window.
- To change the default e-mail software, click the e-mail software.
- Select Outlook in the Select Application window.
Restore MS Office Suite
- Press the Windows key + the R shortcut.
- Type appwiz. In the Run window, click OK to open the uninstall window.
- Select the MS Office suite there.
- Click on the Change (or modify) option.
- If it is MSI-based MS Office, select the Restore option. Click the “Next” button.
- Office suite users should “click” to select the online restore option, and then click Restore.
Removing duplicate office applications
A common email error is often caused by installing duplicate versions of MS Office applications. Some users may have old versions of MS Office applications installed along with new ones. Therefore, removing duplicate MS Office applications can solve the problem.
To do this, open the Windows 10 Start menu and click on the Microsoft Office folder to check for duplicate Office applications. From there, right-click on a duplicate Office program and click Uninstall to remove the application entries that are not associated with your current version of Office.
Frequently Asked Questions
The most common reason why an attachment cannot be sent is that it is too large. These restrictions are set by the person you use for email, whether it's an email account with your ISP or an online provider such as Yahoo or Gmail. Check with your email provider about attachment restrictions.
- Right-click on the tab of the worksheet you want to email.
- If you want to send multiple worksheets, hold down the Ctrl key and click on each one.
- The worksheet will now open in a separate folder with a default name, such as Book1.
- In that worksheet, click File, Share, Email, select Send as an attachment.
In order to share your workbook, some privacy settings must be turned off. Go to File -> Excel Options -> Trust Center, click Trust Center Options, and under the Privacy Options category, uncheck "Remove personal information from file properties when saving".
Excel has a built-in "Send as attachment" feature that allows you to attach a current file to a new email. This email can be created in Outlook or in your default email application. The Send as Attachment button can be found in the File menu or added to the DeepL (QAT) access panel.