From: Sheila on
I am not even sure if this is possible....so I will give you some background
to help you understand what I need... Thanks in advance for any help you can
provide...

I work for a staffing firm and we use various questionnaires to collect
information about our candidates. Each questionnaire is targeted to a
specific type of candidate, i.e. a questionnaire for accounting candidates
versus a questionnaire for an HR candidate or an IT candidate. Each
questionnaire has a set of questions that is specific for that job type, but
each questionnaire also has a set of general questions that is exactly the
same on all of the questionnaires. For example, all the questionnaires ask
what the candidate's top 3 skills are.......but only the HR questionnaire
asks a question about HR related skills. In addition, we have a space to
type job specific questions that have to do with the job opening they are
applying for... For example, if the position requires experience with
specific type of software or ERP system, then there will be a job specific
question for that.

Once it is determined that the candidate is a fit for a particular position,
we bring them in for an interview. In some cases, there is not time to do a
questionnaire.

We have interview forms which include a more extensive list of questions.
The interview form has all of the questionnaire questions on it as well as
other questions.

Right now, when a candidate is coming in for an interview, we prepare the
interview form. Basically, we take the questionnaire that the candidate
previously filled out, and we copy the answers from it into the corresponding
questions that are also on the interview form. We do this so that the
interviewer can see which questions the candidate already answered. In some
cases, a questionnaire was never completed, so there are no answers to copy
over. In some cases, the candidate only answered some of the questions, so
the interviewer needs to get answers for the rest of the questionnaire
questions before moving on to ask the interview questions.

Now here comes the dilemma...

So, we have general interview questions, general questionnaire questions,
job specific questions and title specific questions (HR, IT, etc). We can't
just have one form, because we do not email out the entire list of interview
questions...we only send out the questionnaire questions.

How do we go about making each separate questionnaire answer, EASILY merge
back into the appropriate answer space into a master document?

Is there a way to have one document with say 100 all inclusive
questions.....and then if we email out a questionnaire that only asks like
question #1, #7, # 28, etc.....and the candidate fills out the answers and
emails it back...How do we get those paricular questions to auto merge into
the master document in the appropriate place?

If Word can't do this, can anybody recommend a particular software that can?
--
Thanks!