Need to email a range of cells, two columns, 8 sheets. Possible?

I tried the search, and I guess the terms I used didn't return anything useful, I've tried google, nothing.

Is it possible to email (using Outlook 'Office 2013') two columns, A and F, from 8 separate sheets (all A and F's on each sheet) in the same workbook, but each sheet has a different amount of rows? I've seen the posts showing how to email a rectangular selection, etc, but I don't need a lot of the stuff on the sheet going across on the email, and I've got too many formulas, etc to start messing around rearranging stuff on the sheet.

So,

Sheet1, A1-A55 & F1-F55
Sheet2, A1-A55 & F1-F55
Sheet3, A1-A55 & F1-F55
Sheet4, A1-A36 & F1-F36
Sheet5, A1-A36 & F1-F36
Sheet6, A1-A63 & F1-F63
Sheet7, A1-A63 & F1-F63
Sheet8, A1-A63 & F1-F63

Then, said selections would email off to two people (with the caveat that is may end up being 3 people) as an attachment?

And could I specify in the subject line something like 'Raw Data Sent [date & time]' and even the 'from email' as I have 2 email accounts and I'd like to use the 'other' one?

I'll end up attaching any code to a button, so I can just open up the spreadsheet and hit the button and then close the spreadsheet.

Thanks in advance for any help/code I'm provided.

That I tried, manage attachments allows me to upload said spreadsheet, but then clicking the little 'attachment' in advanced mode yields no results to click.

So I've attached a screenshot of the layout as I don't want to provide personal data like is suggested.

Example.jpg

Guess this is not possible?

.
.
Try this. Paste this macro into a routine module. There is another macro in the project also - review after download of file.

Please Login or Register  to view this content.

Thanks Logit, I've brought that code over to my spreadsheet and I've changed what I needed to do to match my data, etc. In principal it works, but I have a couple of questions.

1) is there a way to copy over the formatting? i.e. some of the cells are red in colour (based on conditional formatting) and some are green. Also, the cells have the boxes around them.
2) is there a way to make this turn into an attachment into the email? rather than copy and paste the contents into the email ready to hit send?

Again, thanks for helping me out with this.

.
.
Creates a PDF file used as an attachment:

Please Login or Register  to view this content.

@Logit @TMS.

Thank you both for your input, time, code and expertise, I've managed to knock together something, using your code and a few tweaks, that works for my needs.

You are welcome.Thank you.

Cheers