Copy Multiple Ranges from Excel to Outlook

**rhudgins** · 09-16-2010, 02:55 PM

I have the following code that copies the excel range D20:E28 to an outlook email. How can I modify the code to also seperatly copy the excel range D14:G17 to the same outlook email?

Any help would be great! thanks

Please Login or Register  to view this content.

**arthurbr** · 09-16-2010, 02:59 PM

Hi maybe this addin by Ron de Bruin would help

**rhudgins** · 09-16-2010, 03:23 PM

That works for copying single ranges. I would like to be able to copy multiple ranges with the click of a button

**snb** · 09-16-2010, 04:34 PM

Wouldn't this be sufficient

Please Login or Register  to view this content.

**rhudgins** · 09-16-2010, 05:02 PM

The code you just gave me doesn't copy the data from the excel sheet to outlook. It is copying the string "C:\test.htm" to the body of the email. Any reasons why?

**snb** · 09-16-2010, 06:12 PM

This is better:

Please Login or Register  to view this content.

**rhudgins** · 09-17-2010, 10:18 AM

After running this macro I am getting a message "This page uses frames, but your browser doesn't support them." I have looked online for a solution to this issue but have not been able to find one. Do you know how to change my setting to support frames?