• Here is my code:

    ########################################

    Declare @MyMessage nvarchar (255)

    Set @MyMessage = 'Sent out emails'

    Declare MyCursor Cursor For

    Select email From fs_users  Where user_id < 35

    Open MyCursor

    Fetch Next From MyCursor Into @MyRecipients

    While @@Fetch_Status = 0

    BEGIN

    Fetch Next From MyCursor Into @MyRecipients

    Exec Master.dbo.xp_sendmail @MyRecipients, @MyMessage

    End

    Close MyCursor

    Deallocate MyCursor

    ########################################

     

    Also, when I hard-coded multiple email addresses, it went out ok.