Query Mailer - Update to put query results in the body of the email

DECLARE
	@dayofweek VARCHAR(100) = datename(dw,getdate())
;
SELECT (CONVERT(DATE, GETDATE()))[Import Date],@dayofweek [Import Day], db_name() [Environment]
;
BEGIN
IF @dayofweek = 'Saturday'
	BEGIN
		SELECT '----------------------------------------------' AS 'Today is Saturday - no Full Forecasts for Sundays'
	END
ELSE
	BEGIN
		Select COUNT(1) AS FullForecastsNotImported
		from tbentityzone ez with(nolock)
		join tbentity e with(nolock) on ez.entityid = e.entityid
		where ez.ZoneID = 770
		AND e.Status != 'Closed'
		and e.TempCloseDate is Null
		AND ez.EntityID not in (
			select EntityID from Forecasting.forecast with(nolock)
			where
			BusinessDay = CONVERT(VARCHAR(10), getdate()+15, 121)
			and GenerationDate > CONVERT(VARCHAR(10), getdate(), 121)
			)
	END
END
;
BEGIN
IF @dayofweek = 'Monday'
	BEGIN
		SELECT '-------------------------------------------------------' AS 'Today is Monday - no Summary Forecasts for Sundays'
	END
ELSE
	BEGIN
		Select COUNT(1) AS SummaryForecastsNotImported
		from tbentityzone ez with(nolock)
				join tbentity e with(nolock) on ez.entityid = e.entityid
				where ez.ZoneID = 770
				AND e.Status != 'Closed'
				and e.TempCloseDate is Null
				AND ez.EntityID not in (
					select EntityID from Forecasting.forecast with(nolock)
					where
					BusinessDay = CONVERT(VARCHAR(10), getdate()+20, 121)
					and GenerationDate > CONVERT(VARCHAR(10), getdate(), 121)
					)
	END
END
;
SELECT '-----------------------------------------------------------------------------' AS 'Count of Forecasts Proccessed by Business Date'
;
SELECT 
COUNT(1) AS ForecastCount,
SUBSTRING(a.AuditDetails, 117, 10) AS BusinessDay 
FROM tbAudit a WITH (NOLOCK) 
WHERE a.AuditDateTime >= CONVERT(VARCHAR(10), getdate(), 121)
AND a.AuditDateTime < CONVERT(VARCHAR(10), getdate()+1, 121)
AND a.AuditCategoryID = 23 
AND a.AuditDetails LIKE '%demand%'
GROUP BY SUBSTRING(a.AuditDetails, 117, 10)
;