Hi all,
I am wondering if anyone knows of a way that I would be able to populate a simple Word document multiple times, using lines of data from an Excel spreadsheet? I've looked up similar threads and tried some possible solutions without much luck.
Here are the details:
I'm using Microsoft Office for Mac 2011 and have a Word template with 4 different info fields that I would like to auto populate using the data I have in an Excel spreadsheet.
The Excel spreadsheet contains four columns and each one is named to correspond to one of the 4 info fields I want populated in the Word document. There are 76 rows of data (4 columns for each row) in my spreadsheet and I want each row to automatically populate one Word template so that I have 76 filled out Word templates in all, each containing the data from its one respective row in the Excel spreadsheet. Is there a way to do this without coding in VBA? I've considered mail merge but I'm not sure it's possible to use it without using a preexisting mail merge template.
I've attached a sample excel data sheet along with a sample of the Word templates I'd be trying to populate using the rows from the Excel sheet.
Thank you in advance to anyone who can help
Bookmarks