[tough teacher]

I am trying to create an exam from an exam data bank. In excel it is
formatted with Question, Answer A, Answer B, etc. This information (over 200
questions) need to be transferred into word. Using mail merge we get
questions 1-5 on the first page, 2-6 for second recipient, 3-7 for third
recipient, etc. How can I get it to run consecutively from 1-200? (New
versions of Excel and Word)

[Doug Robbins - Word MVP]

Use a Directory type mailmerge in the main document of which you have a one
row table with the Question, Answer A and Answer B fields in individual
cells. When you execute that merge to a new document, it will contain a
table with a row of data for each record in the data source.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"tough teacher" tough wrote in message
...
I am trying to create an exam from an exam data bank. In excel it is
formatted with Question, Answer A, Answer B, etc. This information (over
200
questions) need to be transferred into word. Using mail merge we get
questions 1-5 on the first page, 2-6 for second recipient, 3-7 for third
recipient, etc. How can I get it to run consecutively from 1-200? (New
versions of Excel and Word)