Excel formula in Outlook

Brass Contributor



is there any way to get an excel table/formula into outlook?


We want to send it to multiple users, so everyone can fill out the formula.



3 Replies


You can insert an Excel table or formula into an email in Outlook.

Here's how you can do it:

  1. Open Excel and create the table or enter the formula that you want to share.

  2. Select the entire table or the range of cells containing the formula.

  3. Copy the selected cells by pressing Ctrl+C or right-clicking and choosing "Copy."

  4. Open Outlook and compose a new email.

  5. In the body of the email, right-click and choose "Paste" or press Ctrl+V to paste the copied table or formula.

  6. The table or formula will be inserted into the email as a screenshot or as an embedded Excel object, depending on the version of Outlook and the formatting options you choose.

The recipients of the email will be able to see the table or formula and make changes if they have Excel installed on their computer. When they receive the email, they can edit the table or formula directly within the email body and send it back to you.

Note that the editing capabilities may vary depending on the recipient's email client and their access to Excel. It's recommended to communicate with the recipients to ensure they have the necessary software and permissions to make changes to the table or formula.

Additionally, keep in mind that email formatting can sometimes alter the appearance or functionality of complex formulas. Simple formulas are more likely to retain their integrity when pasted into an email.



Thank you!


Is there a way to save the formatted Excel formula as an template in Outlook? 

Would be very helpful, otherwise we would have to copy and insert it every single time.

As far as I'm aware, Outlook doesn't provide a built-in facility to save a formatted Excel formula as a template directly in the application.
You might be able to look for an add-in along these lines in the Microsoft Store.
Otherwise, I don't know of any other immediate solution that could automate it.