Larry Brister
asked on
SQL Server output
How do I take the SQl Statement like below
Set @bodyMail = @header + @textMessage + @tableHeader + @content + @signature + @footer
And email it as an attachment instead of as the body in the attached snippet?
Set @bodyMail = @header + @textMessage + @tableHeader + @content + @signature + @footer
And email it as an attachment instead of as the body in the attached snippet?
EXEC msdb.dbo.sp_send_dbmail
@profile_name='Sql Server',
@recipients='lbrister@mycompany.com',
@subject='Funder OC Review',
@body=@bodyMail,
@body_format ='HTML'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As you like.
ASKER
Excellent. Thanks folks
ASKER
Both are great answers...any problem splitting points with a bit more to ged325 for being firts?