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!

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]