I thought this was solved but have run into another problem.

K. Hobs, your solution works as long as the merge data button is on the excel sheet you are merging to the word dot template. I have six tabs with info on all sheets that are merged to the word dot form: Is there a way you can add the tab name and then the name of the bookmark and column to your code? This way all information from all six tabs will be able to be merged to the dot file bookmarks.

Case "StaffAssault"
col = "E"
Case "InmateAssault'
col = "F"
etc: