Last known video from Meat Loaf was sent to a fan via Cameo