#1
|
|||
|
|||
Inserting spreadsheet data rows as form fields in a document
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 |
#2
|
||||
|
||||
You could use a mailmerge for this.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
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! |
#4
|
||||
|
||||
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] |
Tags |
data, spreadsheet, survey |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Delete Rows in Protected Table with Form Fields | Elan05 | Word VBA | 23 | 09-11-2014 12:47 PM |
Delete Blank Rows (Cyrillic Text in Spreadsheet ) | dozd | Excel | 1 | 02-22-2013 03:24 AM |
Inserting excel spreadsheet into word doc | educpara58 | Excel | 2 | 07-28-2011 01:22 AM |
Problems with inserting rows (2007) | Jo-Anne | Word Tables | 1 | 04-06-2011 03:56 PM |
Using fields to repeat data throughout a document | Brasada | Word | 0 | 07-20-2010 02:37 PM |