You cannot use a WHERE clause with an INSERT operation: INSERT always creates one or more new rows regardless of the rest of the database. (Unless other constraints forbid it in which case teh operation fails.)
Probably, you want:
IF NOT EXISTS (SELECT Email FROM tblUsers WHERE Email = @Email)
BEGIN
INSERT INTO tblUsers ([Name],Email,PhoneNumber)
VALUES (@Name,@Email,@PhoneNumber)
END