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:
- Find the message you want in Outlook, and open the Excel worksheet that you will be using.
- Open a blank document in Microsoft Word
- Drag the message from Outlook to Microsoft Word. An email object will be created in the Word document.
- Then, drag (or copy) the message from Word to where you want it in the Excel sheet.
that's handy, exactly what i needed :) thanks!
ReplyDeleteIf 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
ReplyDeleteWonderful, I surfed the web searching this workaround for ages
ReplyDeleteMany thanks!!