"When one of you visits the ill, then reassure him regarding his lifespan. Indeed that will not repel anything, but it will comfort his soul."
Jami` at-Tirmidhi Book 28, Hadith 52