When he gives up and stands still (staring at you like you’ve gone crazy), THAT’s when you greet your dog and give him some love and attention. This is the reward he was looking for. Following these rules will ensure he learns that he will only earn that reward by not jumping (don’t overdo the high-pitched voice saying, “GOOD BOYYYYY” or it will just rile your dog up even more to start jumping again).
Our inconsistency perpetuates the problem. Some of the time we tolerate the jumping and ignore it. Other times we reward the behavior by exchanging enthusiastic greetings. But when we're dressed up and the puppy's paws are muddy, it's a different story. Reprimanding the puppy for jumping up usually does not work. Either the puppy misunderstands the reprimand as praise or he gets even more excited and the jumping gets worse. If the reprimand is severe enough, the puppy may stop jumping at that moment but it doesn't solve the problem altogether; and it certainly is not a very nice thing to do. It's very similar to a person approaching you with a big smile, arm extended to exchange a hand-shake and you bopping the person in the nose. Even if your puppy learns that jumping up on you is not a good idea, he will usually get away with jumping up on everyone else.
Before you answer the door and welcome guests, clip a leash on your canine, preferably to a front-clip harness or head halter, so that he can be controlled in a manner such that he cannot greet if he jumps. When your dog is calm, with all four paws on the floor — which may take up to a few minutes for more excitable dogs — allow him to approach guests and say hello. If he jumps, gently turn and lead him away; wait for calm behavior before approaching again. For particularly excitable dogs, another option is to remove the dog to a contained area before guests come in. An exercise pen or baby gate is adequate containment for many dogs. If you have an athletic or large dog that can easily scale a gate, use a crate or move him to a room with a closed door. Once your dog calms down, clip on his leash and allow him to come out and greet your guests.