Background: I've used Mail Merge in Word to transfer data in Excel into a Word report using the "Letter" document type.

Problem: I have too many columns ("Recipients" in Word = 407) to complete the task. I'm having difficulty figuring out a manageable way for me to work around this issue.

Googling reveals very vague ways to address this problem and I am not proficient enough in VBA for some of the suggestions. Anyone have any thoughts? Thank you.