Mike Rudolph
asked on
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes. I agree with the desktop publishing concept. Of course never new about lists and thanks Harry for showing me that.
M
M
ASKER
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..