Send Email using Cell Range

[Alpha-87]

Hello,

I have created a workbook with a user dashboard where the user can select from numerous drop down boxes, this then feeds into a further sheet that creates a standard email format using the data collected from these cells.

What I'm trying to achieve and failing miserably at is to have a button on that first sheet "Dashboard" that then sends the data on the "Email" tab as the body of an email and not an attachment using Outlook.

I have data in a range of cells from B2:F24 on the "Email" tab.

I have also got the email addresses of the recipients in cells N5 and N7 "Email" tab.

I'd also like to have the subject line as a standard never changing title.

So, in summary; push the button on "Dashboard" tab, the range of cells on "Email" tab populates the body of an email with text, all sent to the recipient addresses in cells N5 and N7, with the email subject never changing from a set piece of text.

Is any of this even remotely possible or should I try something else instead?

Any help would be greatly appreciated, even if it's just to say that it isn't possible.

Many Thanks

[TMS]

Have a look at Ron de Bruin's website. All you could possibly want to know about emailing pretty much anything, including a range of cells.