Add the same field for multiple records on one page

[joshjmcelroy]

I have a single field on an excel spreadsheet that I need added. I'm creating namecards and I have formatted my excel cell in a field called "finished" with the first name / last name / line break / id# and when I bring that field into Word it works perfect. But I want to then take that "finished" field and have one right after the other on my Word page. Something like this:

{ FINISHED }


{ NEXTRECORD }
{ FINISHED }
{ NEXTRECORD }
{ FINISHED }
{ NEXTRECORD }
{ FINISHED }
{ NEXTRECORD }

The problem is that I can't copy and paste that so I'm entering them one at a time. I just don't want to have to do it over and over for the 100+ entries I have in the excel file. And I also have 4 different excel files I need to do this for, each with a different number of cells.

Any advice on a quicker way to get the merge fields to repeat?

[joshjmcelroy]

Ok...well nevermind. Turns out my default paste option was 'keep text only' so using ctrl-v wasn't working. However, if I right-click and paste using 'keep source formatting' it works!

D'oh.