[OfficeNDN[_2_]]

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.

[Graham Mayor]

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.