Is it possible to write a macro in SQL Server Management Studio that will be displayed in the context menu that comes up when right-clicking a row in the result set of a query? This macro would take and process the contents (data) of that row.
no, you can't do that without some serious SSMS internals hacking.
you can select all data in the grid and copy paste it.