Trying to mail-merge a question/answer list to word, but having difficulty.

[unit25]

Hello,

I have a spreadsheet into which I've entered a bunch of questions and answers for a trivia game, It's just a basic A/B list like this...

Number	Question	Answer
1.	What is...?	The answer is...
2.	Who said...?	The answer is...
3.	Where does...?	The answer is...

I'd like to be able to use mail-merge to pick from this list and create quiz-sheets that are arranged like this:

1. What is...?
The answer is...

2. Who said...?
The answer is...

3. Where does...?
The answer is...

I've tried rearranging the document several ways, but it doesn't seem to work the way I want it to. I know that mail-merge isn't really designed for this sort of thing, but the overall function of moving items from a spreadsheet into a document seems to apply here.

Does anyone know of a way that this might be done?

Thanks!
~Joe

[ramananhrm]

Please try this file.

[unit25]

Hi ramananhrm,

Thanks for the speedy response! That is essentially what I'm trying to do, and it does copy/paste pretty well into Word with a few indent and bullet tweaks.

I'd still be curious to see if there's a way to do it directly into Word from the spreadsheet, but this will do very nicely regardless. Thanks!

In unrelated news, I actually happen to be in India today! I'm in Mumbai for today and tomorrow, then I have a few stops to make in Goa and Kochi in the southwest.

Anyhow, thanks again for the help!

~Joe

[newdoverman]

The end result is done in Word. All Excel is doing is supplying the data to be included in the end document. I have used your small sample to create a mail merge. There are 3 files in this example. The first is the Excel file the second is the Master document into which you insert the Mail Merge fields, and the third file is the result.