Hello, good morning, I am not a programmer either, I am a Human Resources student, nice to hear from you within this community.
A question, what structure does your contact table have? To be able to help you.
If you can send an image of your worksheet, it might be easier to help you.
Meanwhile, from what I read in your code is that in your for each cell. At some point that cell will be the cell that contains the message, which I understand is to the right of the contact. So when the For Each reaches them, on the right it won't find anything.
Greetings from Peru