CODEWITHSUNDEEP
exceloutlookms-officevba
Mutuelinvestor
Mutuelinvestor

Reputation: 3538

Is is possible to edit an excel workbook that has been emailed as the body of an Outlook email

I'm trying to find an easy way to disseminate an excel template to a group of people and them input some data and then email the updated template back to me.
One alternative that I've investigated is sending the excel template as the body of an outlook email and then have the users make there input and email it back.

I came across this article that explains how to email a workbook as the body of an outlook email. The process works great, however, it appears the emailed spreadsheet can not be edited by the recipient.

Question: **Is it possible to not only email the workbook/template as a body of an outlook email, but also make the template editable so the recipient can input data into select cells.

Upvotes: 0

Views: 13697

Answers (1)

Eric Legault
Eric Legault

Reputation: 5834

Unfortunately you cannot make edits and forward the changes when working in the message body (or with a file previewer).

An alternative is to open the email with the attachment and put the email into Edit mode. You can then open the attachment, make changes and save, then save the email and forward it.

Upvotes: 1

Related Questions