Showing posts with label word. Show all posts
Showing posts with label word. Show all posts

Friday, January 25, 2013

Embed an Outlook email into Excel

I needed to embed an email from Outlook into an Excel worksheet.  The only way I could find to do this was to save the Outlook email as a ".msg" file, and in Excel, do an Insert->Object and choose the ".msg" file.  The icon looked odd though, and the embedded object didn't behave like I thought it should.

And then I discovered that Microsoft Word automatically puts Outlook emails into the proper format for an object.

My method for embedding emails from Outlook into Excel added another step, but the finished product is perfect.  The steps are:

  1. Find the message you want in Outlook, and open the Excel worksheet that you will be using.
  2. Open a blank document in Microsoft Word
  3. Drag the message from Outlook to Microsoft Word.  An email object will be created in the Word document.
  4. Then, drag (or copy) the message from Word to where you want it in the Excel sheet.