Email contents of clipboard

Pretty straightforward, is there anyway I can use an excel macro to use the contents of the clipboard as a body of an email?

I was thinking of getting it to open up a html document and using a mailto script that way so that's another option, but for all you VB guys out there, is this possible without having to create a html page?

Not quite what I want, I want to

1) select all
2) copy
3) standard html mailto: body=info on clipboard

We are relying on the users email client, which will be configured (guaranteed) but is not Outlook.

this is also due to file size, even deleting all other sheets still resolves a large filesize, where as when the file is ACSII it's tiny and contains exactly the information I require.

I'll just write a JS code if I have to, but then I have to write an install batch as well, it's just creating more work to need an external source to do this. surley there is just a simple

Send mail to this address command in Excel, though I can't seem to find one.

If you're selecting all, could you just send the sheet as an email? The following code I use to send a sheet by email, doesn't require outlook. Reading it a bit more, it will send the selection as well, so you could send "select all"

Please Login or Register  to view this content.

Edit: I'm an idiot, forgot code tags.

Thanks guys, this was interesting