Database Mail sending to multiple email addresses in the database SQL 2005

I updated the code. It is syntactically correct when I comment out the EXEC msdb.dbo.sp_send_dbmail. 1. Don't know why. 2. In the Assets table, there are multiple assets for the employee. but may have several asset managers that need to be notified. I was trying to create an inner loop just for the asset manager. May need help with this a little more... Thanks!

/* Email Variables */

DECLARE @mailsubject nvarchar(200) DECLARE @themailbody nvarchar (MAX)

/* Cursor Variables */ DECLARE @EmployeeID varchar (50); DECLARE @FunctionalMgrID varchar (50); DECLARE @Job varchar (6); DECLARE @WBS varchar (5); DECLARE @LastworkDate datetime; DECLARE @EmployeeName varchar (50); DECLARE @FunctionalMgrName varchar (50); DECLARE @FunctionalMgrEmail varchar (255); DECLARE @TalentMgrName varchar (50); DECLARE @TalentMgrEmail varchar (255); DECLARE @Library varchar (50); DECLARE @AssetMgrName varchar (50); DECLARE @AssetMgrEmail varchar (255);

/* Cursor - looping through specified CasualEmployee Database Records */ DECLARE Emails CURSOR FAST_FORWARD READ_ONLY FOR

/Statement to fill cursor with data / SELECT [CasualEmployeeDetails].[EmployeeID], [FunctionalMgrID], [Job], [WBS], [LastworkDate], [EmployeeName], [FunctionalMgrName], [FunctionalMgrEmail], [TalentMgrName], [TalentMgrEmail], [Library]
FROM [CDB].[dbo].[CEmpDetails] WHERE [CEmpDetails].[EmailSent] = 0

/* Open the cursor and fill it with the first set of values */ OPEN Emails

FETCH NEXT FROM Emails into @EmployeeID, @FunctionalMgrID, @Job, @WBS, @LastworkDate, @EmployeeName, @FunctionalMgrName, @FunctionalMgrEmail, @TalentMgrName, @TalentMgrEmail, @Library;

/Prepare and send email / WHILE @@FETCH_STATUS = 0 BEGIN SET @mailsubject = 'AMS - Notification: Inactive CASUAL employee with Assets Assigned ' +@EmployeeName+ ':';

SET @themailbody = 'Records indicate that the employee shown below: <br/>
                 -- is defined as a CASUAL status employee<br/>
                 -- has not worked for the last 90 calendar days with PARSONS<br/>
                 -- but has assets assigned<br/>
             <br/>Employee ID:  ' +@EmployeeID+
            '<br/>Employee Name:  ' +@EmployeeName+
            '<br/>Last Work Date:  ' +convert(varchar(30), @LastworkDate, 101)+
            '<br/>Last Work Job-WBS:  ' +@Job+ '-' +@WBS+
            '<br/>Talent Manager: please coordinate with the listed Asset Manager and Functional Manager above to appropriately
             <br/>re-assign this employee assets listed:' +
             N'<H1>Casual Employee Assets</H1>' +
             N'<table boarder="1">' +
             N'<tr><th>Asset Tag</th><th>AssetModelName</th></tr>' +
             CAST ( ( SELECT td = em.AssetTag,               '',
                             td = em.AssetModelName,                     ''
                   FROM       CasualEmployeeAssets 
                   WHERE [CEmpAssets].[EmailSent] = 0  and CEmpAssets.EmployeeID = @EmployeeID
                   FOR XML PATH('tr'), TYPE) AS NVARCHAR(MAX))+ N'</table>' + N'Reference: '+ @Library;


Select distinct top 1 [AssetMgrName]
                    ,[AssetMgrEmail]

      FROM [CDB].[dbo].[CEmpAssets]
      WHERE [CEmpAssets].[EmailSent] = 0  and EmployeeID = @EmployeeID                

---- ---- ----EXEC msdb.dbo.sp_send_dbmail ---- @profile_name = 'CasualAsset', ---- @recipients = @TalentMgrEmail, ---- @copy_recipients = @AssetMgrEmail, ---- @subject = @mailsubject, ---- @body_format = 'HTML', ---- @body = @themailbody;

  UPDATE [CEmpDetails] Set [EmailSent] = 1, EmailSentDate = GetDate() WHERE EmployeeID = @EmployeeID

-- UPDATE [CEmpAssets] Set [EmailSent] = 1, EmailSentDate = GetDate() WHERE EmployeeID = @EmployeeID

  FETCH NEXT FROM Emails INTO @EmployeeID, @FunctionalMgrID, @Job, @WBS, @LastworkDate, @EmployeeName, @FunctionalMgrName,
                             @FunctionalMgrEmail, @TalentMgrName, @TalentMgrEmail, @Library;

  END 


  CLOSE Emails
  DEALLOCATE Emails