I have a workbook that has daily sheets that i need to email from a list in Address sheet.
I want to Attatch the Active Sheet as an Attatchment and then from the same sheet to select a range of cells to be in the body of the email.
The idead is when the email is received the attachment is there to open and the body of the email has some detail