Merge one Excel file into multiple Word Documents
Hello,
I am trying to find a way to merge one excel spreedsheet into multiple word documents. I have to do this by state because of legal language and currently have to open each document separately and select the lines from the excel sheet. Obviously, with 50 states this can be very time consuming.
Is there a way to set it up so that the merge can look at the data in a cell, in this case, I use column AM and each state is always the two letter abbreviation, and have it open a file and merge that line of data before moving on to the next line?
|