Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge Fields & Query Options
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/cindy...faq1.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 "SamoneMaritn" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailmerge directories not working Word 2003 | Mailmerge | |||
Mail Merge insert merge fields | Mailmerge | |||
mail merge putting fields in the wrong place! | Mailmerge | |||
How to get all mail merge fields in a document | Mailmerge | |||
mail merge and access query | Mailmerge |