Every 2 months, I have to mail merge a lengthy document from Excel. I've got a field in the Word doc that matches the row heading in Excel, but I can't find a way to make Word figure that out and populate it for me.
This is my data document in Excel. The rows represent each individual letter in Word, and the columns are what is populating my mail merge. I have about 225 columns, so I use row 2 as a test to make sure I got them in order after manually merging the document.
This is my document to which the data goes. Again, each column populates the "Qty" column for each letter.
My thought is that because the SHS item in Word is exactly the same as the header in Excel, there should be some way to automate this. Maybe I'm dreaming. I'm not advanced enough to know how to write code or VBA. Any thoughts would be amazing.
This is my data document in Excel. The rows represent each individual letter in Word, and the columns are what is populating my mail merge. I have about 225 columns, so I use row 2 as a test to make sure I got them in order after manually merging the document.
This is my document to which the data goes. Again, each column populates the "Qty" column for each letter.
My thought is that because the SHS item in Word is exactly the same as the header in Excel, there should be some way to automate this. Maybe I'm dreaming. I'm not advanced enough to know how to write code or VBA. Any thoughts would be amazing.
