Prince Harry was "absolutely loved" when he was a working member of the Royal Family, says Queen Elizabeth's former press secretary.