That still doesn't tell me anything about your particular problem. In any event, the code you posted is overkill for a problem such as this - much of it is simply irrelevant. Did you actually add the macro in post #12 to your mailmerge main document?
I see you've now started a duplicate thread:
https://www.msofficeforums.com/mail-...l-merging.html
Kindly don't do that. In any event the problem as described there is quite different: it's not only column 2 that might be empty.