Mail Merge Fields & Query Options

[Guest]

Hi,
I would like to be able to pull data from an Excel spead sheet into MS WORD
2002. To create a form letter.

Example Spread Sheet:

Employee Comments 1

Jane Doe Jane is doing well with data entry a pleasure to work with
Jane Doe Exceptional Employee a pleasure to work with
Jane Doe Needs to work on customer Service skills
Sandy Joe Sandy seems to have compasion for patients and loves her job
Sandy Joe Needs to work on team work and helping others as needed
Sandy Joe Great employee with alot of compassion

What I am trying to do is create a form letter that will allow to me to
combine all the comments for each employee on one sheet for each person who
has reviewed them. I have over 7-8 comments sections that have 5-6 different
reviewers. And rating scores on my spread sheet that includes reviewwers
names who gave the comments. I have tried setting it up several different
ways with the fields

Form Letter Sample:

2006 Performance Review of Employees

Name: <<Name of Employee>> Date: Jan 2006

How well does the employee preform there job?
<< Comments 1>> I would like to have reviewer 1's comments listed here
<< Comments 1>> I would like to have reviewer 2's comments listed here

etc.......

How well does the employee respond to customer needs?
<< Comments 2>> I would like to have reviewer 1's comments listed here
<< Comments 2>> I would like to have reviewer 2's comments listed here

I know that there is a simple way to create this form but my mind is fried
trying to figure it out. Please Help.

Thanks,
Samone

 

[Doug Robbins - Word MVP]

That amounts to a "multiple items per condition (=key field)" mailmerge
which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at :

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at :
http://cornell.veplan.net/article.aspx?&a=3815

Warning, it is not going to be particularly easy for the format that you
want to achieve grouping the responses from different reviewers by employee
and then by question.


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