How to I transfer a large data set into word and populate many sheets based on a template.

Caleb
Caleb used Ask the Experts™
on
I have a large column of numbers in Excel. I have a name that will remain the same.

I want to populate many pages, based on a template, from the Excel data. One page per number. Numbers and pages need to be kept in the same order.
Example.docx
Example.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Retired
Top Expert 2012
Commented:
As far as I can tell from the exanples and description, a letter-type of mail merge should do that.

Word has a walk-through under: Mailings tab, Start Mail Merge group, Start Mail Merge dropdown, Step-by-Step Mail Merge Wizard...
CalebFire Protection Engineering Intern

Author

Commented:
I didn't know that was a built in feature. Thank you!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial