Is there a way to get Word to pull from a table or Excel sheet a series of numbers, BUT: put different numbers on the same page? Every time I’ve seen MS mail merge used, it’s assumed that
I’d like to make pages something like this, with sequential numbers put in specific spots, and not repeating:
Page 1
1 2
3 4
Page 2
5 6
7 8
What I can think of right now is having each row in Excel have four columns with sequential numbers, and have Word pull those four columns into different parts of the document. This seems to be quite a process; making records with only four parts, and needing them to be exactly in sequence.
1 2 3 4
5 6 7 8 etc.
Doing this by hand is not really acceptable, as there are orders that need tens of thousands of numbers used.
Making a file like that in Matlab or something similar would be trivial if Excel can’t do it easily. Save it as comma-separated numbers and Excel should be able to read it.
Since I posted, I found that Excel will autofill grids of numbers, so that is solved. Now my problem is that Word is putting the merged data in a different spot from the Field. When I view the data, I get different distances from the right margin. The Field is against the right margin, but the actual printable data is not. It’s not even in part of the Field; it’s actually outside it. I tried adjusting the alignments of the Excel data, but I guess that’s not it.
[INDENT][/INDENT]Field as viewed: aaaaaaaaaaaaaaaa «Field_6»
Data as viewed: aaaaaaaaaaaa 14