Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Directory by department
Hello
I am trying to put together a directory using the mail merge and directory tool in Word 2007. The list for the names would come from an excel spreadsheet. I would like to list employees by department. Rules would be used to list employees of one department (for example, Education department) before going to the next department. I was think of something like "IF «Position_Title» EQUALS "Education" THEN" and I am not sure what to put after that. Would it be "LIST"? The formula could be listed each time with "Education" replaced with the new department. The directory could just be updated in the excel spreadsheet instead of having to type in a whole new directory each time someone gets hired/leaves. Also the departments have varying numbers of employees working in them so rules would have to be made to include all of them. I am very unaware of the rules/codes in word so if my example above is nowhere close please forgive me. Your help is greatly appreciated. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Directory by department
This is a lot more complicated to achieve than you might imagine - see How
to use mail merge to create a list sorted by category in Word 2002 - http://support.microsoft.com/?kbid=294686 The principle remains true for Word 2007. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org OfficeNDN wrote: Hello I am trying to put together a directory using the mail merge and directory tool in Word 2007. The list for the names would come from an excel spreadsheet. I would like to list employees by department. Rules would be used to list employees of one department (for example, Education department) before going to the next department. I was think of something like "IF «Position_Title» EQUALS "Education" THEN" and I am not sure what to put after that. Would it be "LIST"? The formula could be listed each time with "Education" replaced with the new department. The directory could just be updated in the excel spreadsheet instead of having to type in a whole new directory each time someone gets hired/leaves. Also the departments have varying numbers of employees working in them so rules would have to be made to include all of them. I am very unaware of the rules/codes in word so if my example above is nowhere close please forgive me. Your help is greatly appreciated. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
a directory? | Mailmerge | |||
intra department promotion notice | Microsoft Word Help | |||
directory | Mailmerge | |||
welcome letters for employee transferred to new department | Microsoft Word Help | |||
human resoures department | Microsoft Word Help |