I tend to say something along the line of "If you need anything, let me know.", or "don't hold in the tears, it's fine to be sad for a while", or similar.
^ I'm not good at the emotional stuff. So I try to base it on logic and psychology. <.<