Macro to email range instead of the whole sheet

**igoodable** · 07-20-2016, 05:27 PM

The codes below works perfectly, but when I un-comment 'range("a1:c6").select, the macro goes crazy and go into a continuous loop. I only want to send range a1:a6 as body instead of the whole sheet.

Please Login or Register  to view this content.

**jeffreybrown** · 07-20-2016, 05:35 PM

Try Ron's email page

**igoodable** · 07-20-2016, 05:51 PM

I need help understanding the error please... More specifically, why does defining a range breaks the program?

**apo** · 07-21-2016, 07:02 AM

Hi..

I would be going with SNB's version of sending a contiguous range in email..

http://www.snb-vba.eu/VBA_Excelgegev...len_en.html#L4

It can be adapted to send non-contiguous ranges too..

**igoodable** · 07-21-2016, 10:17 AM

I'm not really looking for a solution. I'm interested in learning vba on a deeper level. In this case, I want to know why defining a range cause the program to crash. It cause outlook and excel to into a continuous loop.

If I manually select a range before executing the macro, it works, but I can't programmatically select a range.

**igoodable** · 07-21-2016, 11:49 AM

I'm more boggled that if I do range a1:b6, it works fine!! Column C is just ordinary values, nothing special or different about the rest of the columns. SOMEONE HALLPP!!!

Sample file attached.

If I change Set Sendrng = Worksheets("lagg").Range("A1:b" & rangea) to Set Sendrng = Worksheets("lagg").Range("A1:C" & rangea), excel will go crazy.