Email Data Range from Excel using Outlook

Hello Everyone,

I am trying to build a issue tracker template for our IT team. One of the features in this template is, once a user enters a line item, the most recent line item should be e-mailed to the IT team. I am using the code shown below for this purpose

I would like to keep the selection range (columns B thru H and the most recently entered row) dynamic. For this, I am using a variable for the most recently entered row number (which I have stored in cell A2 on the active sheet). However, I cannot get the macro to select the most recent range.

I would appreciate any help you can offer.

Thanks,

Please Login or Register  to view this content.

Thanks for replying John,

You were right, that was indeed the erronous line (which I had figured out). I havent tried your solution yet but I kept messing with the vba range selection options and this worked for me.

Please Login or Register  to view this content.

Thanks again for trying. Appreciate your help.

I just tried your solution and that worked too. Thanks for you input John.