I think I might disagree with Savvy on this particular one. 'Out of' is to me an equivalent to 'From', as in 'He fainted from fright'. And this does not sound ok to my ear. But maybe I'm wrong after all...
However, Pieanne's suggestion 'Fright made him faint' is still my favorite, as of today...