View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Mail merge to Word 2007 - multiple data sources

Although nothing to do with Mail Merge, something vaguely similar came up a
while back in a different forum. You *may* be able to adapt the suggested
method to your requirements or it may give you some ideas on how to progress
this issue.

http://groups.google.co.uk/group/mic...+question+sets

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Fev wrote:
Hi
I am trying to set up a template for exam question papers for a
university. They would like to create a database of questions (with
allocated marks). As there are 4 types of questions a) Multiple
Choice b) Short questions c) Discussion questions and d) Essay
questions each with their own set of instructions, and slightly
different layout, I thought of doing the following:
1. Create a directory type mail merge document for each of the 4
question types.
2. Use the INCLUDETEXT field to bring these docments into the final
question paper
3. Use table calculations and bookmarks to calculate the marks per
section and total marks
A further requirement is to create a marking memorandum at the same
time. The marking memorandum would be generated in the same way,
using the same selection of questions, but merging the answer fields
into 4 seperate docs, and follow the same 3 steps as above.
Has anyone had experience in doing this who could point me in the
right direction. I would greatly appreciate any help/suggestions.
Regards
Heather