Using MS Word mail merge to populate table

Hello Experts..

I`ve attached a spreadsheet of almost 5000 columns called `Price List`

I am trying to mail merge that list into a word document so that I can get the entire list on 8 pages in Word. I do not know how to get the mail merge to go vertical first on each page then horizontal to fill up the page then move onto the next page. I'm stuck on this one.

I attempted to just cut and paste as you can see with the attachments but the document comes to (9) pages and I need it to be (8) pages.

I thought I could do this with a mail merge but not sure. Also when I tried initially to mail merge the second number field in the Excel document shows up will trailing digits - don't know where they came from.

Any assistance you can provide would be most appreciated.

Thanks!

M
Price-List--1-.xlsx
Price-List.docx
Price-List--Cut.xlsx
shogun5Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Harry LeeCommented:
shogun5,

What you are trying to do has nothing to do with mail merge. What you need is Columns in word.

The truth is there are so many rows of data, which is meant to be a long list no matter how you put it in Word.

I have the font set to 5, which is pretty much unreadable, and not repeating the Column headers in every column. Still that will be 13 pages in Word.

Take a look at the file I have attached.

Is there any reason it has to be 8 pages?
Product.docx
0
shogun5Author Commented:
HarryHYLee,

Thanks! But this is for a product booklet at needs to be 8 pages. I could simply cut and paste the values and make it work but I thought I'd try a mail merge. Or this if is not a mail merge project then was going to try to find out a better way to populate all 8 pages. I need labels at the top of each row as in the example.

This may not be doable. But wanted to see if it was..
0
RartemassLife CoachCommented:
I think you almost have it with your cut and paste example. If you narrow the left and right margins you can add in another column of data in each page. This should give you ample room to insert the data from page 9.

Is larger paper available to you such as A3?

Seeing how this is for a booklet this may be easier to set up in a desktop publishing application such as Adobe InDesign (licensed) or Scribus (free).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shogun5Author Commented:
Yes. I agree with the desktop publishing concept. Of course never new about lists and thanks Harry for showing me that.

M
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.