Hi, with some help today I was able to get my stored procedure running
and have the results emailed to me. However, this is how its showing
up:
Accounting_Year WK_IN_FYEAR Location
GL_Account
Col Data Difference
--------------- ----------- ------------------------------------
----------
-------------------- -------------------- --------------------
2007 49 Test1
500-001
-2587872.0200 -2587872.0200 .0000
2007 49 Test2
500-001
-3344713.5000 -3344713.5000 .0000
2007 49 Test3
500-001

Is there anyway to line them up side by side properly? When i have two
colms selected the format comes out ok. Thanks for all the help
again!

Here is the sp:

CREATE PROCEDURE [dbo].[spEmailVariance]
(
@SubjectLine as varchar(500),
@EmailRecipient VARCHAR(100)
)
AS

DECLARE @strBody varchar(5000)
set @SubjectLine = 'Weekly Flash Update'
SET @strBody =

'Select statement'


exec master.dbo.xp_sendmail
@recipients= 'XX@XXXX.com',
@subject= @SubjectLine,
@query = @strbody

RETURN
GO