#1
|
|||
|
|||
Creating a list in Word from an Excel spreadsheet
I would like to create a list in a Word document. The information I need is in an Excel spreadsheet - 100+ rows across four columns. (they are a series of questions and possible answers for a quiz)
I have set up the page using Mail Merge like this: «Question» «Answer_One»«Question» «Answer_One»With the idea of getting this: Which landmark is a prehistoric monument which still stands in the English county of Wiltshire? Stonehenge Who is the patron saint of Ireland? St Andrew But when I complete the mail merge I get this: Which landmark is a prehistoric monument which still stands in the English county of Wiltshire? StonehengeWhich landmark is a prehistoric monument which still stands in the English county of Wiltshire? StonehengeHow do I fix this so I get a sequential series of questions rather than the same one repeated? Thanks for your help! |
#2
|
||||
|
||||
Hi gingernut,
Your could use a Directory/Catalog merge with just the first set of fields, or you could insert a «NextRecord» field before the second «Question» field.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Inserting excel spreadsheet into word doc | educpara58 | Excel | 2 | 07-28-2011 01:22 AM |
Creating mailing labels from list in excel | wordnoob2 | Mail Merge | 0 | 12-13-2010 03:46 PM |
Creating a spreadsheet | nickypatterson | Excel | 1 | 01-14-2010 03:21 PM |
Word Fill-in form with Excel spreadsheet | karik | Word | 0 | 01-11-2010 08:45 AM |
Creating a Distrubution List from Excel | webphotogeek | Outlook | 0 | 01-10-2008 11:21 AM |