Crime Scene: Another vote steering you toward Al-Anon. It is not for users, it is for people exactly like you have described your situation with this friend and other relatives.
Someone once ignored the disgusting alcoholic that was living in the same body and told me, with love and respect I didn’t have for myself, nor deserve from them, that they were worried about me, and thought I should get help. They learned how to do that through Al-Anon, and it worked.