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.