DECLARE @out_desc VARCHAR(1000), @out_mesg VARCHAR(10) DECLARE @name VARCHAR(20), @birthdate datetime, @email NVARCHAR(50) DECLARE @body NVARCHAR(1000) DECLARE C1 CURSOR READ_ONLY FOR SELECT [name], [birthdate], [email] FROM Customers OPEN C1 FETCH NEXT FROM C1 INTO @name, @birthdate, @email WHILE @@FETCH_STATUS = 0 BEGIN IF DATEPART(DAY,@birthdate) = DATEPART(DAY,GETDATE()) AND DATEPART(MONTH,@birthdate) = DATEPART(MONTH,GETDATE()) BEGIN SET @body = ' Happy Birthday ' + @name + ' Many happy returns of the day' + ' Customer Relationship Department' EXEC sp_send_mail sender@abc.com', 'xxxxxxx', @email, 'Birthday Wishes', @body, 'htmlbody', @output_mesg = @out_mesg output, @output_desc = @out_desc output PRINT @out_mesg PRINT @out_desc END