Excel – is Outlook 2010 Changing the Embedded Spreadsheet to a GIF?

emailmicrosoft excelmicrosoft-outlookmicrosoft-outlook-2010

Years ago I figured out how to embed a spreadsheet in an Outlook email to automate a task I do regularly. Whenever I want to send a new quote request I open an old email, tell Outlook I want to resend it, fill in the new values in my embedded spreadsheet and then send it off. This method worked well for years.

After switching to a new computer however, I have found that when I open the latest emails I have sent, I cannot edit the embedded spreadsheet because Outlook interprets it now as a GIF. Saved emails that I sent with the old computer however, still work fine – I can still open, edit and resend and Outlook interprets the embedded spreadsheet correctly.

I would like to figure out how to setup Outlook in the new PC correctly so that the embedded spreadsheet is interpreted correctly when the email is reopened. Some sort of security setting, maybe? Any help anyone could provide would be appreciated.

I developed the spreadsheet originally in Excel. Then I went into Outlook, created a new email, did Insert->Object->Excel Spreadsheet. At that point I had a blank spreadsheet in my email. Then I copied and pasted the spreadsheet from Excel into the blank spreadsheet in Outlook and it worked perfectly (until this recent problem)

Best Answer

When you send emails, make sure they are sent as Rich Text, not HTML (which is the default in Outlook 2010). Rich Text is the only hope you have of saving the full document. This is found in the Format Text tab of the ribbon in a new message window.

Sadly, there's no way to recover the original spreadsheet(s) from the emails that have already had the conversion done on them.