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, to copy and paste the email message from Outlook in Excel, the message is mess and total out of formatting. Actually, you can embed the email message as an object into the workbook as follows:
Step 1: In Microsoft Outlook, highlight the email message that you will work with.
Step 2: Click the File >> Save as in Outlook.
Step 3: Go to the Microsoft Excel workbook that you will embed the email message in, and click the Insert >> Object.
Step 4: In the Object dialog box, click the Create from file tab.
Step 5: Click the Browser button to load the email message that you save as in Step 2.
Step 6: Click OK.
Then it will display the email message icon in the workbook as the following screen shot shows:
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 a blank object as following screen shot shows, and it will open the email message with double clicking.
If you check the Display as icon option in the Object dialog box, you will get an icon embed in workbook as the following screen shot shows, and it also can open the email message with double clicking.
