In this article:

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

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

How to Insert Outlook Email in Excel

Follow the simple steps below to insert Outlook Email into Excel. 

1. Open Outlook and Select Email for Embedding

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

how to insert outlook email in excel

2. Use 'Save As' to Download Email in Outlook Format

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'.

insert outlook email in excel

3. Open Excel and Prepare to Insert Object

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

insert outlook email into excel

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

how to insert an outlook email into excel

4. 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.

5. 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.

6. 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 Outlook email in Excel. If you enjoyed this article, you might also like our article on how to insert email into excel or our article on how to create a mailing list 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!