Press button, send email

I need code that essentially copies a cell range (A1:I20) and pastes it as body of an email, as if I had copied and hit control v in the body myself.
I've seen numerous links but I can't seem to make it work.
Also, the title will always be "Attendance" and a date referencing from a cell on a different tab (Attendance 2/3/18, for example)
The button is on a different tab ("Forms") than the target cells. The target cells to copy will be on a hidden tab ("Percap"). Date is on "Cover"

https://www.rondebruin.nl/win/s1/outlook/mail.htm

I've tried that before. It tells me selection is not a range or the sheet is protected. I set the range to A1:I20 and the sheet is not protected. Here is my code:

Please Login or Register  to view this content.

.

Please Login or Register  to view this content.

It still doesn't work, I'm afraid. It thinks the Rng=Nothing still. I can't tell you why, the form is not protected. Your spreadsheet worked fine, so it's not Outlook. What would cause it to think the range is nothing?

Something else is going on with your computer or Excel ... the example project functions as intended here.

The macro requires that Outlook is installed on your computer ... and ... you will need to establish a default email account within Outlook.

The sample works on my computer as well. Outlook has a default email set and opens up a new message the way it should after clicking the example button. Here's the file, it's been greatly scaled down. The code in question is in module 66. Also, any tips for condensing those modules? Each one is just a button that prints a range. It takes forever to save.

After downloading your file ... I was able to view just a few of the Modules, including #66. After that, each time I attempted to open any module (even the ones that had opened previously) I would receive an error message indicating ".DLL not available".

Do you have any reference in your coding that is calling a .DLL ?

Of the modules I was able to view, it appears each one is printing out a different range of data from the sheets. If they all print out a hard copy (paper) version of the indicated data, why not place all of the print commands into a single
module and call that single module with one Command Button ? Again, I wasn't able to see all of the modules so my assumptions about the purpose of the modules may be inaccurate.

Sorry I can't be of more assistance due to the .DLL error message.

I will try opening it on a different computer tomorrow, and see if there's anything I can find. As far as I'm aware, there is no.dll file being referenced. I didn't make the original spreadsheet, I'm just updating it with numerous improvements to save time closing our cash room. Each of those buttons print out different forms. It really is an impressive spreadsheet. I will report back after I try and open it tomorrow.