I'm merging from excel into a table in word 2010. Table has two columns of data coming from excel.



I've put the "nextrecord" at the end of each cell in the table (except the last), and at the beginning of each cell (except the first). No matter which way I try, the first 3 or 4 cells are accurate, then it skips to every 4th row from the excel data.

Also, I've ensured there are no extra spaces or redundant rules in the word table.


Thanks,
/e

Next Record jumps to the next record. If you have it twice in a cell it will skip records.

This sounds like a Many to One merge - see Merge Many To One

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Thanks so much for your input.

I'm basically moving content from several columns in a single excel file, to cells in a table in the word file.

For instance:

column G of the excel will be placed cell by cell into column 2 of the table

column J of the excel will be placed cell by cell into column 3 of the table

...and so on

I've checked that "nextrecord" is never repeated in a cell in the word file.

Attached Images

merge image.PNG (12.5 KB, 14 views)