I want it to take a set range on a specified worksheet and paste it into the body of an email and send it off. Then close the workbook without saving. I have some code that works, but only about 40% of the time. I've tried it on Excel 2007 & 2010 and cannot consistantly get the range to paste. Any assistance would be greatly appreciated. Here is the code:
Please Login or Register to view this content.
Bookmarks