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)