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

Caleb used Ask the Experts™
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.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2012
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


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