Create a excel report on failed instances with error message

This utility will generate the info you need, but you will need to work out whether you can automate it:-
https://bobj-board.org/t/111635


Mak 1 :uk: (BOB member since 2005-01-06)