View Single Post
 
Old 03-05-2015, 12:35 PM
joshjmcelroy joshjmcelroy is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Mar 2015
Posts: 2
joshjmcelroy is on a distinguished road
Default Add the same field for multiple records on one page

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?
Reply With Quote