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

You could use a mailmerge for this.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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!

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?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]