Merge Excel Data into Word but NOT as a letter format?

T

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)
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top