Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Excel Data into Word but NOT as a letter format?
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) |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Excel Data into Word but NOT as a letter format?
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) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
After merge I need to see the letters under the prompt box to edit | Mailmerge | |||
WP merge file to Word | Tables | |||
Word 2002 cannot find its Excel data source for mail merge | Mailmerge | |||
Word Field Codes in Excel data file | Mailmerge |