Generate results of summary to ANY kind of file

I have the need to generate a file to email automatically.
I have done this previously but only with a grid.
I know there has to be a way to do this.

Please advise if you have any thoughts.

Kevin