Many-body theory of electronic excitations in random substitutional alloys