Thread: [Solved] Creating a list in Word from an Excel spreadsheet
View Single Post
 
Old 03-19-2013, 03:29 AM
gingernut gingernut is offline Windows XP Office 2003
Novice
  
Join Date: Mar 2013
Posts: 1
gingernut is on a distinguished road
Default 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»
«Answer_Two»
«Answer_Three»
«Answer_Four»
«Question»
«Answer_One»
«Answer_Two»
«Answer_Three»
«Answer_Four»
With the idea of getting this:

Which landmark is a prehistoric monument which still stands in the English county of Wiltshire?
Stonehenge
Hadrian’s Wall
Offa’s Dyke
Fountains Abbey

Who is the patron saint of Ireland?
St Andrew
St David
St George
St Patrick

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?
Stonehenge
Hadrian’s Wall
Offa’s Dyke
Fountains Abbey
Which landmark is a prehistoric monument which still stands in the English county of Wiltshire?
Stonehenge
Hadrian’s Wall
Offa’s Dyke
Fountains Abbey
How do I fix this so I get a sequential series of questions rather than the same one repeated?

Thanks for your help!
Reply With Quote