Variables And Xp_sendmail

Goal--I want this script to go through some tables and look at some equipment ID's and whoever has equipment assigned to them I want to send an e-mail to them telling them to bring in the equipment for inventory.

Problem--On line 28 I set my xp_sendmail variable "@query" equal to a select statement. Inside that select statement I refer to a variable @USERNAME from outside of the query. I get a must declare variable error. Is there any way to refer to a variable from outside this select statement?

Any suggestions?

Thanks!!!

SET NOCOUNT ON
go
PRINT 'Determining which users to email ...'
PRINT ' '
go
DECLARE @USERNAME varchar(30)
DECLARE USERNAME_CURSOR CURSOR FOR
select DISTINCT A.UserName from tblMISFixedAssetTable2 A, tblMISFixedAssetTable B
where A.BarCodeID = B.BarCodeID
and A.UserName is not null
and B.MobileEquipment = '-1'
and A.LastUpdate = (Select Max(C.LastUpdate)
FROM tblMISFixedAssetTable2 C
WHERE C.BarCodeID = A.BarCodeID)

OPEN USERNAME_CURSOR
FETCH NEXT FROM USERNAME_CURSOR INTO @USERNAME
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
SELECT @USERNAME = RTRIM(@USERNAME)
exec master.dbo.xp_sendmail
@recipients = @USERNAME,
@subject = 'Inventory 2002',
@message = 'Please bring in your Portable/Mobile Equipment',
@query = 'SELECT A.BarCodeID, B.ItemCategory, B.ItemDescription
from MISAsset.dbo.tblMISFixedAssetTable2 A,
MISAsset.dbo.tblMISFixedAssetTable B
where A.BarCodeID = B.BarCodeID
and A.UserName = @USERNAME
and B.MobileEquipment = "-1"
and A.LastUpdate = (Select Max(C.LastUpdate)
FROM MISAsset.dbo.tblMISFixedAssetTable2 C
WHERE C.BarCodeID = A.BarCodeID)'
EXEC ("PRINT 'Emailing the user * " + @USERNAME + " with inventory items.*'")
END
FETCH NEXT FROM USERNAME_CURSOR INTO @USERNAME
END
DEALLOCATE USERNAME_CURSOR
PRINT ' '
PRINT 'Done!'
PRINT ' '
go