View Single Post
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
SamoneMaritn SamoneMaritn is offline
external usenet poster
 
Posts: 1
Default Mail Merge Fields & Query Options

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