Declare @Housing Table
(
  ukID varchar(100)
  ,email varchar(500)
)

Insert Into @Housing (ukID,email) Values
('11', 'red@gmail.com'), ('2', 'green@gmail.com')
,('433', 'fire@gmail.com'), ('987', 'purple@gmail.com')

Declare @email varchar(500)

Declare cursor1 cursor For

Select Distinct(email) email
FROM @Housing
ORDER BY email asc

OPEN cursor1

Fetch Next From cursor1 INTO @email

While @@FETCH_STATUS = 0
BEGIN

    Print @email

    Fetch Next From cursor1 Into @email

END

Close cursor1

Deallocate cursor1