Susan Smith had been writing letters to a man, but the communication has now stopped. "It's over," a family member tells PEOPLE