How can I generate a wide message or report with a macro?

How can I generate a wide message or report with a macro?

I've a spreadsheet with a lot of data on multiple sheets. I would like to generate, based on that content, a kind of report which I would like to copy & paste into an e-mail program or on a formular in another website.

The only way to do this was using the "msgbox" statement. But this is very inflexible, the number of lines are limited, it is not possible to insert CRLF, so it works only for short messages. 

Isn't there any possibility to extract data from the spreadsheet and generate a report? Perhaps to generate a text file which I can download afterwards?