It works. Pretty quickly.
Hang the bell up near the door. Not ON the door, but near it, at a height that the pup can easily reach with his head or paw.
Each time you get ready to take him out, say "You want to go outside?", and as you do, help him to touch the bell. Food reward, and go out.
He will learn very quickly.