[Nicole Knapp]

I have a document that is a certificate. I have a spreadsheet that is an
attendance sheet for a training session.

The Word document is a mail merge which pulls data for "credit hours",
"course", "Name", "Location" and "date". This is pulled via SQL from a
table created separately based on the spreadsheet.

My spreadsheet has header information in the first 11 rows that basically
stays the same between each - the "hours", "Course", "Location" and date are
all in the same cells each session. The names are located in a specific
column below the header

I would like to eliminate moving the data out of the spreadsheet to the
table and have Word and Excel interact directly to create certificates for
each attendee.

Thanks.