Populate a custom Word document using data from Excel?

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

to populate a simple Word document multiple times, using lines of data

Sounds like a job for <dramatic pause>... Super Mail Merge.

Use Mail Merge from within Word. No coding required. There are several good tutorials on YouTube.