In this article:

How to Insert Email into Excel (Easiest Way in 2024)

In this article, we will show you how to insert email into Excel. Simply follow the process below.

Can you Insert an Email into Excel?

Inserting email content into Excel is both feasible and practical. This can be achieved through various methods such as copying and pasting the text and using integration features with programs like Microsoft Outlook.

How to Insert an Email into Excel

Follow the steps below to insert an email into Excel by copying and pasting text.

1. Copy the Desired Email Text

Open the email you need to insert into Excel. Highlight the desired text, right-click, and choose 'Copy', or press 'Ctrl + C'.

insert email into excel

2. Insert Copied Content into a Selected Excel Cell

Switch to your Excel workbook. Click on the cell where you want the email content. Right-click on the cell and select 'Paste', or simply press 'Ctrl + V' to place the copied email content.

how to insert email into excel

3. Resize Excel Cell to Fit the Pasted Email Content

If the pasted content is too big for the cell, adjust the cell size. Click and drag the cell borders to make sure all content is visible.

how to insert an email into excel

4. Apply Formatting to the Pasted Email Content for Clarity

Format the pasted content to match your Excel sheet's style. Adjust font, size, color, or alignment using Excel's formatting tools.

how to insert email in excel

5. Save Your Excel Workbook with the New Email Content

After inserting and formatting the email content, save your Excel file. Click 'File'.

insert email in excel

Then click 'Save', or use the keyboard shortcut 'Ctrl + S'.

how to insert an email in excel

How to Insert an Outlook Email into Excel

Follow the simple steps below to insert or embed an Outlook email into Excel.

1. Select Email for Embedding and Download Email in Outlook Format

Locate and open the email in Outlook that you want to embed in Excel.

insert an email into excel

In the open email, click on the three dots in the top right corner. Select 'Save As' from the dropdown menu. The email will be downloaded in 'Outlook Message Format - Unicode' format.

insert email to excel

2. Open Excel and Prepare to Insert Object

Open Microsoft Excel and navigate to the worksheet where you want to embed the email.

can you insert an email into excel

In the 'Insert' tab on the ribbon, find and click on 'Object' in the 'Text' group.

3. Embed Email in Excel Using 'Create from File'

In the 'Object' dialog box, select the 'Create from file' tab. Click 'Browse' to locate and choose the saved Outlook email. Click 'OK' to insert the email into your Excel sheet.

4. Adjust Size and Position of Embedded Email

Once the email is embedded, adjust its size and position within your Excel worksheet to suit your layout and presentation needs.

5. Optional: Set Email to 'Link to File' or 'Display as Icon'

For dynamic updates, check 'Link to file' to have the embedded email update when the original Outlook email changes.

For a more compact display, choose 'Display as icon' to represent the email as an icon in Excel.

We hope that you now have a better understanding of how to insert an email into Excel. If you enjoyed this article, you might also like our article on how to email an Excel spreadsheet or our article on how to insert Outlook email in Excel.  

Schedule a free automation consult
Learn more

Level up your Google Sheets skills with our free Google Sheets automation guide

Wasting too much time doing things manually in spreadsheets? Want to spend more time doing what you love? Our 100% free, 27-page Google Sheets automation guide is full of new tips and tricks that will save you time and money!