Alcoholism is only a symptom of the problem. He clearly has lots of pain that needs to be addressed. You need to get his family or maybe a close friend informed. If nothing else, take it to HR. It's not an ordinary coworkers job to offer counseling on such a troubling matter. Also, his competency as a functioning alcoholic shouldn't have any influence in how to deal with this situation.