I've looked around for tips on e-mailing from excel, however, i can't find something quite specific to what i want to do.

I want to send an e-mail out of a set range

I can get it to work for a whole workbook, but I want to set the range myself in the program.

I don't want to select the data (i've seen posts on this) I just want to have a set range of cells that will be sent out when I press a button

Thanks for your help