Hello! - I am trying to move data from Excel to a template letter made with Word. When I manually do the process, after selecting the correct data in Excel, and right clicking on the table in word I get the below option, "Merge Table (M)". For the life of me, I cannot figure out how to do this with VBA though.

I have tried the standard application.selection.pasteandformat, after selecting the table, of course, but it continuely puts the data ABOVE the table.

Anyone have a suggestion? TIA!

2016_12_06_14_32_37_.png