How to Embed Email in Excel
To embed an email in Excel, go to the Insert tab, click Object, choose Create from File, browse to a saved .msg email file, and click OK — the email opens as a clickable object right inside your worksheet. If you only need a clickable reference rather than the full message, insert a hyperlink to the email’s location instead. Both methods take less than a minute and work on Windows and Mac.
This guide covers every way to insert an email into Excel: embedding the full message as an object, linking to a saved email file, attaching emails so they travel with the workbook, and the troubleshooting steps for when the object refuses to open. You will also find the differences between the Windows and Mac workflows, the keyboard shortcuts that speed things up, and answers to the most common questions.
What “embed an email in Excel” actually means
People searching for this want one of three slightly different outcomes, so it helps to name them up front:
| Goal | Best method | Result in the workbook |
|---|---|---|
| See the full email content inside the sheet | Insert as an Object | An icon or live preview you can double-click to open |
| Keep the file small but still reach the email | Insert a hyperlink to the saved .msg file | Blue clickable text that opens the email |
| Make the email travel with the workbook | Embed (not link) the object | The email is stored inside the .xlsx file |
The key distinction is embed vs. link. An embedded object is copied into the workbook, so the email goes wherever the file goes — great for sharing, but it grows the file size. A linked object only stores a path, so the workbook stays small but breaks if the original email is moved or deleted. Choose based on whether the recipient will have access to the original email.
Before you start: save the email as a file
Excel can only embed an email that exists as a file on disk. In Outlook for Windows, open the email, choose File → Save As, and save it as Outlook Message Format (.msg). On a Mac, drag the email from Outlook straight onto your Desktop to create a .eml or .msg file. Note the folder you saved it to — you will browse to it in the next step.
Method 1: Embed an email as an object (Windows)
This is the most reliable method and does not require the Developer tab.
Step 1: Open the Insert dialog
Click the cell near where you want the email, go to the Insert tab on the ribbon, and in the Text group click Object.
Step 2: Create from file
In the Object dialog, switch to the Create from File tab. Click Browse, find your saved .msg email, and select it.
Step 3: Choose embed or link
- Leave both boxes unchecked to embed the email inside the workbook.
- Check Link to file to keep a smaller workbook that points to the original message.
- Check Display as icon to show a compact Outlook icon instead of a large preview.
Step 4: Click OK
The email lands on your sheet as an object. Double-click it to open the full message in Outlook. To reposition or resize it, click once to select, then drag the handles — the same way you would move an inserted picture in Excel.
Method 2: Embed an email using the Developer tab
If you specifically want to embed a live Outlook item type, the Developer tab exposes the Microsoft Outlook Email Message object.
- Enable the tab: File → Options → Customize Ribbon, then check Developer. (This is the same toggle you use to insert a checkbox in Excel.)
- On the Developer tab, click Insert, then choose the More Controls or Object command.
- Pick Microsoft Outlook Email Message from the object type list, or use Create from File to point at an existing message.
- Resize and position the object on your sheet.
For most people, Method 1 from the Insert tab is faster and avoids the extra setup. Use the Developer tab only if you need an interactive Outlook control rather than a static embedded message.
Method 3: Insert a hyperlink to an email (smallest file size)
If you do not need the email’s body inside the sheet, a hyperlink is cleaner and keeps the workbook light.
- Select the cell.
- Press Ctrl + K (Windows) or Cmd + K (Mac) to open the Insert Hyperlink dialog.
- Choose Existing File or Web Page, browse to the saved
.msgfile, and click OK.
Clicking the cell now opens the email. You can also use the HYPERLINK function for a formula-driven link, or add a hyperlink in Excel the standard way. To create a mailto: link that opens a new draft instead, type =HYPERLINK("mailto:name@example.com","Email John") in the cell.
Embedding email in Excel on a Mac
The Mac version of Excel handles objects slightly differently:
- Insert → Object exists on the Mac ribbon, but the object types available depend on what is registered with macOS. If Outlook Message is not listed, use the drag-and-drop method below.
- Drag and drop: with both apps open, drag the email from Outlook directly onto the Excel worksheet. Excel inserts it as an embedded object.
- Hyperlink shortcut: press Cmd + K to link to a saved
.eml/.msgfile.
If an embedded object will not open on Mac, it usually means the file type is not associated with an installed app — saving the email as a PDF first is the most portable fix (see troubleshooting).
Keyboard shortcuts that speed this up
| Action | Windows | Mac |
|---|---|---|
| Insert hyperlink | Ctrl + K | Cmd + K |
| Copy selected object | Ctrl + C | Cmd + C |
| Paste object | Ctrl + V | Cmd + V |
| Open ribbon Insert tab | Alt, then N | — |
There is no single hotkey for the Insert Object dialog, so the Insert-tab ribbon path is the fastest route. Once an object is placed, the standard copy and paste shortcuts duplicate it across cells or sheets.
Embedding multiple emails in one sheet
To group a whole thread or project together, repeat Method 1 for each message. A few tips keep things tidy:
- Display each as an icon (Display as icon) so a dozen emails do not crowd the grid.
- Select several objects with Shift + click, then right-click and choose Group to move them as a unit.
- Put the email objects on their own worksheet — adding a new worksheet dedicated to correspondence keeps your data tabs clean.
Alternatives worth knowing
Embedding emails as objects is powerful but heavy. Depending on your goal, one of these may fit better:
- Embed a different file type. The same Insert → Object workflow lets you embed any file in Excel, including Word docs and ZIPs.
- Save the email as a PDF and embed that. PDFs open everywhere, so embedding a PDF in Excel (or inserting a PDF) is the most shareable option.
- Pull contact data out of Outlook instead. If you really want the information — names, addresses, dates — export Outlook contacts to Excel or open a VCF file in Excel and work with the data directly.
- Add a signature block. If the goal is to sign off a sheet, insert a signature in Excel rather than embedding a whole email.
Troubleshooting embedded emails
The object shows an icon but won’t open
Double-clicking an embedded .msg requires Outlook to be installed and set as the default mail handler. If nothing happens, open Outlook once, then try again. On a Mac, the .msg format may not be recognized — re-save the email as a PDF and embed the PDF instead.
”Cannot insert object” error
This usually means the file is open in another program or the path contains characters Excel dislikes. Close the email in Outlook, move the file to a simple folder path (no special characters), and retry. Linking instead of embedding also avoids the error in some cases.
The embedded email looks blank or broken after sharing
You almost certainly used Link to file rather than embedding. A linked object stores only a path, so the recipient sees nothing. Delete the object and re-insert it with Link to file unchecked so the message is stored inside the workbook.
The file got huge
Each embedded email adds its full size to the workbook. Switch to hyperlinks for emails you do not need to view inline, or embed PDFs (which are typically smaller than raw .msg files). You can also compress the Excel file — though linking is the better long-term fix.
Printing the embedded email
Select the object first, then go to File → Print. To control whether objects print at all, check Page Layout → Sheet Options, or compare this with how you print comments in Excel.
Frequently Asked Questions
How do I embed an email in Excel?
Go to the Insert tab, click Object, choose the Create from File tab, browse to a saved .msg (or .eml) email, and click OK. Leave “Link to file” unchecked so the email is stored inside the workbook, and check “Display as icon” if you want a compact view. Double-click the object to open the full message.
How do I insert an email address into Excel as a clickable link?
Select the cell and press Ctrl + K (Windows) or Cmd + K (Mac), choose E-mail Address, and type the address. Excel creates a mailto: link that opens a new draft when clicked. You can also type =HYPERLINK("mailto:name@example.com","Send email") directly in a cell.
How do I attach an email to an Excel file so it stays with the workbook?
Use Method 1 and make sure Link to file is unchecked. An embedded (not linked) object is copied into the .xlsx file, so the email travels with the workbook when you email or share it. A linked object only stores a file path and will appear blank to anyone without the original message.
Can I embed an email in Excel without Outlook?
You can embed it as a file, but opening an embedded .msg requires Outlook because that is the format’s native handler. The workaround is to save the email as a PDF first, then embed the PDF — PDFs open on any device without Outlook.
How do I embed an email in Excel on a Mac?
The simplest way is to drag the email from Outlook directly onto the worksheet, which inserts it as an embedded object. Alternatively use Insert → Object if “Outlook Message” appears in the list, or press Cmd + K to hyperlink to a saved .eml/.msg file. If the object will not open, save the email as a PDF first.
Can I update an embedded email after the original changes?
Only if you linked rather than embedded it. Linked objects can be refreshed to reflect changes in the source file. A fully embedded email is a static snapshot — to update it, delete the object and re-embed the latest version of the message.
The bottom line
Embedding email in Excel keeps your correspondence and your data in one place. Use Insert → Object → Create from File to embed the full message, a Ctrl + K hyperlink when you want a lightweight clickable reference, and save-as-PDF when the workbook needs to open on machines without Outlook. Match the method to whether the recipient has access to the original email, watch your file size when embedding many messages, and you will have a tidy, self-contained workbook that travels well.
