How to embed an Excel (2010) Worksheet into Outlook 2010

I have an end user that would like a button configured to basically copy the contents of an Excel 2010 worksheet and directly insert it into Outlook. Right now there is the option in Excel to send as attachment but nothing that will allow to send as the body of the message.
Who is Participating?
byundtConnect With a Mentor Commented:
Ron deBruin has a set of web pages that show numerous different ways of automating email with Excel. If you want to copy the contents of a worksheet into the body of an email, you might consider the code at

You can link the macro in deBruin's web page to a button in Excel.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.