Inserting spreadsheet data rows as form fields in a document

[b3nz]

Hello,



I had an online form that was a survey. I've exported the data into an excel spreadsheet. I'd like to use those answers and print them out page by page, with all the answers to person 1 on one page, all answers by person 2 on second page, etc.

Is there a function in word to take data rows/columns and insert them as specific fields (similar to the mail merge function, i'm guessing)


Example (database file):



Final Outcome (Word Doc):
Page 1 - Jon:

Apples or Oranges
Apples

A, B, or C
B

Day of the week?
Monday

Page 2 - Sue:

Apples or Oranges
Oranges

A, B, or C
A

Day of the week?
Friday

Page 3 - Jeff (etc.)
Apples or Oranges
Apples

A, B, or C
C

Day of the week?
Wednesday

[macropod]

You could use a mailmerge for this.

[b3nz]

I've tried using mail merge, but I think the problem is that there are both multiple rows and multiple columns, so the data isn't corresponding properly.

Am I just doing it wrong? Thanks!

[macropod]

The snapshot you posted indicates only one row per person, so an ordinary letter merge should do fine. Are you actually completing the merge (via Finish & Merge), or merely previewing it?