Skip to main content

How to insert or embed an Outlook message in Excel?

Sometimes you want to embed an Outlook email message in a workbook. You may think of copy the email content and paste into workbook. However, after copying and pasting the email message from Outlook in Excel, the message is getting mess and total out of formatting. Actually, you can embed the email message as an object into the workbook as follows:

insert or embed an Outlook message in Excel as an object

insert or embed an Outlook message in Excel as an object

1. Firstly, you need to save an Outlook email which you need to insert into worksheet. Please select the email message in the Mail List in Outlook, then click File > Save As. And in the Save As dialog box, specify a folder for saving the email message, enter a name for the email as you need in the File name box, keep the Outlook Message Format - Unicode option in the Save as type drop-down list, and finally click the Save button. See screenshot:

2. Go to the Microsoft Excel workbook and open the worksheet that you will embed the email message in, then click te Insert > Object.

3. In the Object dialog box, go to the Create from file tab, click the Browser button to find and select the email message that you haved saved in Step 1. After selecting the email message and rerurning to the Object dialog box, click the OK button. See screenshot:

Then the specified email message is inserted into current worksheet as the following screenshot shown:

Note: In the Object dialog box, it is optional to check the Link to file option and the Display as icon option.

If you check the Link to file option in the Object dialog box, you will get an email message embedded in current worksheet as below screenshot shown, and the embedded email can be opened with double clicking.

If you check the Display as icon option in the Object dialog box, you will get an icon embedded in current worksheet as the following screenshot shown, and it also can be opened with double clicking.

Best Office Productivity Tools

Supercharge Your Spreadsheets： Experience Efficiency Like Never Before with Kutools for Excel

Popular Features: Find/Highlight/Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup  |   Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns   |   Move Columns   |   Unhide Columns   |   Compare Columns to Select Same & Different Cells ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar   |  Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells   |  Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolset:  12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   Many More...

Kutools for Excel boasts over 300 features, ensuring that what you need is just a click away...

Supports Office/Excel 2007-2021 & newer, including 365   |   Available in 44 languages   |   Enjoy a full-featured 30-day free trial.

kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (24)
No ratings yet. Be the first to rate!
Gary
Gary
This comment was minimized by the moderator on the site
Is there a way to do this with Excel in Microsoft Teams? As far as I know, this feature is NOT supported in Excel in Teams.
Reply
0
0
Debra Guenther
Debra Guenther
This comment was minimized by the moderator on the site
Perfect instructions on how to link an email to a spreadsheet. Thank you!
Reply
0
0
Meher Sharan
Meher Sharan
This comment was minimized by the moderator on the site
Can you please tell me how to break password using macro based file.
Reply
0
0
Faizan
Faizan
This comment was minimized by the moderator on the site
Can you please share the trick to embed an email from outlook directly.
Reply
0
0
Lord Meyer Rothschil
Lord Meyer Rothschil
This comment was minimized by the moderator on the site
Why so complicated???
Reply
0
0
Jennish Lal
Jennish Lal
This comment was minimized by the moderator on the site
thanks!!! its a great help for me.
Reply
0
0
Hoorah
Hoorah
This comment was minimized by the moderator on the site
Shift/print screen then paste in the cell.
Reply
0
0
Saqib Manzoor
Saqib Manzoor
This comment was minimized by the moderator on the site
Dear Thanks its work 8) BR, Saqib
Reply
0
0
Gabster
Gabster
This comment was minimized by the moderator on the site
Ray, thanks! That is way faster then the other options.
Reply
0
0
ice
ice
This comment was minimized by the moderator on the site
Hi people, Has anybody faced the condition as below? My colleagues will paste a 'table'(the information i requested from them) into the text paste in the mail textbox, i will then copy the whole table and paste it into the excel. So, in the end , whenever i open the excel file , its will always prompt me and error message that it will close it for me and 'recover' the file for me. The file is never able to be opened. And, my IT department claimed that the file is being corrupted. But, i think that it is not about the file being corrupted. What do you guys thing ?
Reply
0
0
renekok
renekok
This comment was minimized by the moderator on the site
Nice guide but my question. When you add a file to your worksheet like you did, does that mean that i can open that file on another computer (for example in another country as we have more offices) or does it only link to a location on my computer? I need it to be inside the worksheet so everyone can acces the 'file' regardless of their location. is that possible? Thx and good health
Reply
0
0
Ray
Ray     renekok
This comment was minimized by the moderator on the site
Yes. When you paste the Outlook messaging into the embedded Word object inside your Excel spreadsheet, it is embedded in the document, not a link to a file. So as you pass the file around to different computers, each will see the embedded file. Hope this helps. Ray
Reply
0
0
Mithell
Mithell     Ray
This comment was minimized by the moderator on the site
Is there a way to actually put the e-mail in a cell of the spreadsheet?
Reply
0
0
Mithell
Mithell     Ray
This comment was minimized by the moderator on the site
Can you put an e-mail in a particular cell of a spreadsheet?
Reply
0
0
Yared
Yared
This comment was minimized by the moderator on the site
Why the envelope icon doesn't appears?, I am on the six step and haven't selected any of the next two options. Regards.
Reply
0
0
Ray
Ray
This comment was minimized by the moderator on the site
Here's another way. To avoid the intermediate use of MS Word, insert a Word object within your excel spreadsheet (Insert, Object, Create New, select MS Word Document). When you double click on the Word object, it engages Word to the extent that you can copy/paste an Outlook email into the Word portion of your Excel file, thus bypassing the additional step of copying to Word first, then moving it to Excel.
Reply
0
0
Stephanie
Stephanie     Ray
This comment was minimized by the moderator on the site
I needed this! Thank you Ray!
Reply
0
0
bereket
bereket     Ray
This comment was minimized by the moderator on the site
Could you please show us step by step on how to perform the task. Thanks,
Reply
0
0
Ray
Ray     bereket
This comment was minimized by the moderator on the site
In Excel (I am on version 2010): * Place your cursor within your Excel file where you desire to embed a Word object. * Click on the INSERT menu item * Then click on OBJECT in the ribbon bar * A dialog box is displayed that has a tab, CREATE NEW; select this tab * In the list of object types, scroll to locate and select "Microsoft Word Document"; make sure "Display as Icon" is unchecked * Then click OK You now have a Word object embedded in Excel. You are able to type into this object just as if you were in MS Word. When you click away from the object, you will still see the object, with a box around it, and whatever text you entered. To get back into the Word document, double click on the object and begin entering desired text. In my case, I created a table in the Word object, one column to type in the name of someone, and the adjacent column to paste the Outlook message. In Outlook, in the Mail main screen, click on the desired email message. Right click on the message and select COPY. This copies the email message to the clipboard. Then go back to your Excel file, in the Word object (double click the object to open up Word), right click, then select PASTE. The result will be an icon representing your email message. Then when you subsequently double click on the message icon, the email message will be displayed. Hope this helps. Ray
Reply
0
0
Van
Van
This comment was minimized by the moderator on the site
I have embedded emails into a work book, but now I want to be able to sort and filter the data (there is more than just the embedded email in the work book. I am finding when I sort the data, even when clicking "expend the selection" the emails will not sort with the rest of the data. Can someone help?
Reply
0
0
Weston
Weston     Van
This comment was minimized by the moderator on the site
If you copy and paste into Word then cut and paste into the cell you are wanting the file to go to, it will be sortable. It makes my life easier, or at least I hope it will. :D
Reply
0
0
Muhammad Anas
Muhammad Anas
This comment was minimized by the moderator on the site
Thank you.It was so easy. May Allah bless you.
Reply
0
0
Tom
Tom
This comment was minimized by the moderator on the site
For me it's quicker to just drag the email from Outlook into a blank Word doc, then copy (Ctr+C) the embedded file in the Word doc and paste (Ctrl+V) the file in Excel. Close the Word doc without saving, or if you're using an already open Word doc, just delete the embedded email from there.
Reply
0
0
Ray
Ray     Tom
This comment was minimized by the moderator on the site
Tom, Too bad that you can't copy / paste an Outlook email into Excel the same way you do in Word, to avoid using Word as an intervening application.
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations