Using MS Word mail merge to populate table

Posted on 2013-09-03
Medium Priority
Last Modified: 2013-09-03
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.


Question by:shogun5
  • 2
LVL 12

Assisted Solution

by:Harry Lee
Harry Lee earned 1000 total points
ID: 39462284

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?

Author Comment

ID: 39462338

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..
LVL 18

Accepted Solution

Rartemass earned 1000 total points
ID: 39462749
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).

Author Closing Comment

ID: 39462754
Yes. I agree with the desktop publishing concept. Of course never new about lists and thanks Harry for showing me that.


Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article describes a serious pitfall that can happen when deleting shapes using VBA.
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question