Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge directories not working Word 2003 Chris Mailmerge 5 January 16th 07 01:41 PM
Mail Merge insert merge fields Dannyl Mailmerge 1 December 12th 06 05:51 AM
mail merge putting fields in the wrong place! Disa Mailmerge 1 September 18th 06 09:24 AM
How to get all mail merge fields in a document [email protected] Mailmerge 3 February 17th 06 05:43 AM
mail merge and access query DaveAS Mailmerge 6 January 6th 05 06:33 PM


All times are GMT +1. The time now is 12:05 AM.

Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"