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.

3 comments:

  1. that's handy, exactly what i needed :) thanks!

    ReplyDelete
  2. If you want to maintain the position of the icon (in the Excel worksheet), right-click on the icon, select Format Object / Properties Tab / Move but don’t size with cells

    ReplyDelete
  3. Wonderful, I surfed the web searching this workaround for ages

    Many thanks!!

    ReplyDelete