Since the xpstar.dll suggestion didn't work for me, I had to find another workaround. I used xp_cmdshell and bcp to save the query results to a file, then used sp_send_dbmail to attach the file. Same end result, but a two step process.